FreePremium93 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.
93
SQL Problems
Difficulty Breakdown
93 problems5 Easy(5%)
24 Medium(26%)
59 Hard(63%)
5 Expert(5%)
Skills You'll Practice
114 skillsacquisition cohortactive usersadtechadvanced cteaggregationanti joinanti patternarravgbankingcalendarcase whenclassificationcleaning transformcoalescecohortcohort 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 fnswindow function
All Problems93 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.