SQL quiz
Ten questions, instant answers. Take the mixed round or pick a level.
Question 1 of 10
Find employees earning more than $90,000.
What the quiz covers
57 questions, one from each lesson. Every answer links to the lesson that explains it.
Beginner
- Introduction to SELECT
- Selecting Specific Columns
- Filtering with WHERE
- Multiple Conditions with AND/OR
- Sorting with ORDER BY
- Limiting Results with LIMIT
- Range Queries with BETWEEN
- Multiple Values with IN
- Pattern Matching with LIKE
- Column Aliases with AS
- Sorting by Several Columns
- Paging with OFFSET
- NULL Values and IS NULL
- Excluding Rows with NOT
- COALESCE - Handling NULLs
- CASE WHEN - Conditional Logic
- Type Casting with CAST
- Math Functions
- Working with Dates
Intermediate
- Counting with COUNT
- SUM and AVG
- MIN and MAX
- Grouping with GROUP BY
- Filtering Groups with HAVING
- Unique Values with DISTINCT
- Introduction to Subqueries
- Subqueries with IN
- Subqueries in FROM
- Combining Tables with INNER JOIN
- LEFT JOIN - Keep All Left Rows
- Finding Rows Without a Match
- Joining Three or More Tables
- UNION and UNION ALL
- INTERSECT and EXCEPT
- String Functions
- Grouping by Dates
- Conditional Aggregation
- Finding Duplicates
- The Order SQL Runs In
Advanced
- Introduction to Window Functions
- RANK and DENSE_RANK
- PARTITION BY
- LAG and LEAD
- Introduction to CTEs
- CTEs with Window Functions
- Self Joins
- Recursive CTEs
- Query Optimization Basics
- NTILE - Dividing into Buckets
- Aggregate Window Functions
- Running Totals and Moving Averages
- Percent of Total
- Growth Rates with LAG
- EXISTS and NOT EXISTS
- Correlated Subqueries
- Finding the Median
- Gaps and Islands: Finding Streaks
Practice on your iPhone
Query Dojo for iPhone has 85 interview questions, timed mock interviews and a tile builder, so you can write queries without a keyboard.