FreePremium136 ProblemsSQL
SQL Window Functions Practice with Built-In Visualizer
Master SQL window functions — the most-tested topic in data science interviews. Practice ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, NTILE, running totals, and moving averages across real company-style datasets. The built-in SQL Visualizer shows you exactly how each window frame computes its result, making it easy to debug partition and ordering issues.
136
SQL Problems
Difficulty Breakdown
136 problems3 Easy(2%)
44 Medium(32%)
83 Hard(61%)
6 Expert(4%)
Skills You'll Practice
97 skillsadtechadvanced windowaggregationamortizationanomaly detectionavgavg overbankingcase whencleaning transformcoalescecomputed columnconsecutive dayscountcount distinctctectescumulative sumdaily returndata bucketingdatedate arithmeticdate timedense rankengagementevent streamfilteringfintechfirst valuefood deliverygoogle bigquery flavorgoogle interviewgroup bygrowth ratehealthcareidle timeoutinner joininterview classicislands and gapsjoinjoinsjuliandaylagleft joinlodginglogisticsmessengermeta interviewmin maxmobilitymonth over monthmoving averagemoving windowmulti ctemulti joinmulti tablentilenulliforder bypartition bypaymentspercent rankpercentage changerankreal estateretailrolling averageroundrow numberrows betweenrows framerows unboundedrunning totalsaassession idsessionizationsingle tablesocialsortingstreak detectionstreamingstrftimesubquerysumsum overtelecomthree table jointie breakerstie breakingtime seriestop ntop n per grouptwo table joinunion three tableswherewindow fnswindow function
All Problems136 total
Explore more topics
Practice with 1,500+ problems across SQL and Python — window functions, joins, pandas, and more.
All company names, logos, and trademarks are the property of their respective owners.
Their use is for identification purposes only and does not imply endorsement.