FreePremium92 ProblemsSQL
SQL Subqueries & CTE Practice with Built-In Visualizer
Build fluency with scalar subqueries, correlated subqueries, EXISTS/NOT EXISTS, IN/NOT IN, and Common Table Expressions (CTEs). The built-in SQL Visualizer walks you through CTE execution order, showing intermediate result sets so you can debug complex multi-step queries.
92
SQL Problems
Difficulty Breakdown
92 problems5 Easy(5%)
24 Medium(26%)
58 Hard(63%)
5 Expert(5%)
Skills You'll Practice
112 skillsacquisition cohortactive usersadtechadvanced cteaggregationanti joinanti patternarravgbankingcalendarcase whenclassificationcoalescecohortcohort analysiscohort retentioncommentscomparisoncompliancecomputed columnconditional aggregationcorrelated subquerycountcount distinctcross sellctectesdate arithmeticdate spinedate timedepthderived columnderived tabledistinctexistsfilteringfintechfirst event anchorfood deliveryfour table joingap fillgoogle interviewgroup byhavinghealthcarehierarchyin subqueryinner joininterval overlapinterview classicjoinjoinsjuliandayleft joinloan servicinglodginglogisticsmaxmissing datesmobilitymonth walkermulti ctemulti joinmulti stepmulti tablemulti table joinnot existsnot innullifnumeric thresholdoperationspartition bypaymentspercentagerankreal estaterecursive cteretailretentionretention mathriskroasroundrow numbersaassaas metricsscalar subqueryscenario sqlscorecardself joinself referencesingle tablesocialsocial graphsortingstaff levelstreamingsubquerysumtelecomthreadthree table jointie breakerstime seriestop 1 per grouptop ntree traversaltwo table joinwherewhere clausewindow function
All Problems92 total
Explore more topics
Practice with 1,625 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.