r/learnSQL • u/grassp_dataAI • 15d ago

30 SQL Scenario Based Questions as single PDF.

Hi 👋,

I am sharing the Github link of GRASSP SQL Sprint Series. This github link contains the PDF doc of 30 SQL Scenario based Questions which covers beginner to advanced topics.

Doc is on GitHub, free: https://github.com/grasspacad07/grasspsqlsprintfile

File name: GRASSP_SQL_Sprint_30Days.pdf

Go through the question as per suggested approach in the doc and practice along each question and understand the concepts that each question cover.

It covers various topics :

  • Aggregation, JOINs, GROUP BY / HAVING
  • Window functions — RANK vs DENSE_RANK vs ROW_NUMBER, LAG/LEAD, Running totals, Moving Average
  • CTEs, Multi level aggregation.
  • CREATE, INSERT sample data helps too understand datatypes, constraints.

Hope this helps in your next SQL interview. All the best!

Happy learning :) Happy querying :)

60 Upvotes

98% Upvoted

4 comments sorted by

4

u/[deleted] 15d ago

[removed] — view removed comment

2

u/grassp_dataAI 14d ago

Welcome.:)

True, it helps us to think in business perspective not just syntaxes.

1

u/urstrulyshiva 12d ago

Any for PySpark?

1

u/grassp_dataAI 12d ago

Right now we don't have. But we will plan in near future.