TheShiraverseSELECT * TheShiraverseCurriculumPracticeKahaniFAQGet StartedPlaygroundNukteTheShiraverse ↗

SQL practice questions

11,200 free questions across 28 topics. Four levels each: Easy, Medium, Hard and Crazy. Every question is a real business scenario on RetailMart, the practice database of this course.

Start here: Get StartedTry the SQL Playground
Practice is separate from the video topics: learn a topic first, then come here to make it stick. Answers are coming soon.
Topic 01
Intro to SQL
Easy 100Medium 100Hard 100Crazy 100
Topic 02
Basic Queries
Easy 100Medium 100Hard 100Crazy 100
Topic 03
DDL and DML
Easy 100Medium 100Hard 100Crazy 100
Topic 04
Data Types and Constraints
Easy 100Medium 100Hard 100Crazy 100
Topic 05
Filtering and Sorting
Easy 100Medium 100Hard 100Crazy 100
Topic 06
Scalar Functions
Easy 100Medium 100Hard 100Crazy 100
Topic 07
Conditional Logic
Easy 100Medium 100Hard 100Crazy 100
Topic 08
Aggregates and Grouping
Easy 100Medium 100Hard 100Crazy 100
Topic 09
Joins Part 1
Easy 100Medium 100Hard 100Crazy 100
Topic 10
Joins Part 2
Easy 100Medium 100Hard 100Crazy 100
Topic 11
Subqueries Part 1
Easy 100Medium 100Hard 100Crazy 100
Topic 12
Subqueries Part 2 and LATERAL
Easy 100Medium 100Hard 100Crazy 100
Topic 13
CTEs
Easy 100Medium 100Hard 100Crazy 100
Topic 14
Database Concepts
Easy 100Medium 100Hard 100Crazy 100
Topic 15
Subqueries and CTEs Combined
Easy 100Medium 100Hard 100Crazy 100
Topic 16
Window Functions Part 1
Easy 100Medium 100Hard 100Crazy 100
Topic 17
Window Functions Part 2
Easy 100Medium 100Hard 100Crazy 100
Topic 18
Window Functions Part 3
Easy 100Medium 100Hard 100Crazy 100
Topic 19
Reading Query Plans
Easy 100Medium 100Hard 100Crazy 100
Topic 20
Indexing for Analysts
Easy 100Medium 100Hard 100Crazy 100
Topic 21
Pivoting, Unpivoting and FILTER
Easy 100Medium 100Hard 100Crazy 100
Topic 22
Median, Percentiles and DISTINCT ON
Easy 100Medium 100Hard 100Crazy 100
Topic 23
Date, Time and Time Series
Easy 100Medium 100Hard 100Crazy 100
Topic 24
JSON and Semi-Structured Data
Easy 100Medium 100Hard 100Crazy 100
Topic 25
Views and Materialized Views
Easy 100Medium 100Hard 100Crazy 100
Topic 26
Data Quality and Deduplication
Easy 100Medium 100Hard 100Crazy 100
Topic 27
Cohort, RFM and Funnel Analysis
Easy 100Medium 100Hard 100Crazy 100
Topic 28
Review and Interview Prep
Easy 100Medium 100Hard 100Crazy 100