- Executors
-
Learn
Learn Python Runnable examples, NumPy, pandas, and more Learn AI / Machine LearningNeural networks, ML and LLMs from scratch Learn C & C++ Pointers, memory, STL, and modern C++ Learn C#C# basics, OOP, LINQ, async, and .NET exercises Learn MatplotlibLine, bar, scatter and pie charts with live visualizers Learn RustOwnership, traits, error handling, and threads Learn GoSlices, interfaces, goroutines, and channels Python Algorithms Search, sorting, recursion, and visualizers O(n) C & C++ Algorithms Compare algorithms implemented in C and C++ Coding for Kids Learn to code by playing!
- QuizzesNew
- ChallengesNew
- For TeachersNew
- Updates
- Buy me a coffee
SQL Quizzes
30 SQL quizzes with 300 multiple-choice questions, from easy to hard. Every answer is explained.
30 quizzes · 300 questions
6 categories
SQLite
SQL categories
4 Easy1 Medium
SELECT & WHERE
ORDER BY & LIMIT
DISTINCT
+2
0 of 5 passed
Start
1 Easy4 Medium
COUNT, SUM, AVG, MIN & MAX
GROUP BY
HAVING
+2
0 of 5 passed
Start
1 Easy2 Medium2 Hard
INNER JOIN
LEFT JOIN
Self Join
+2
0 of 5 passed
Start
3 Medium2 Hard
Subqueries
EXISTS vs IN
Common Table Expressions (WITH)
+2
0 of 5 passed
Start
1 Easy4 Medium
INSERT, UPDATE & DELETE
Constraints & Keys
Transactions & ACID
+2
0 of 5 passed
Start
2 Medium3 Hard
Classic SQL Interview Queries
SQL Output Prediction
Tricky NULL Questions
+2
0 of 5 passed
Start
matching quizzes
1
SELECT & WHERE
Easy
Pick the columns you want and keep only the rows that match a condition.
SQL · SQL Basics
#select#filtering
10 questions · ~5 min
Not started
Start
2
ORDER BY & LIMIT
Easy
Sort query results and keep only the first few rows.
SQL · SQL Basics
#sorting#select
10 questions · ~5 min
Not started
Start
3
DISTINCT
Easy
Remove duplicate rows from a result and count unique values.
SQL · SQL Basics
#select#duplicates
10 questions · ~5 min
Not started
Start
4
LIKE, IN & BETWEEN
Easy
Filter rows with text patterns, lists of values and ranges.
SQL · SQL Basics
#filtering#patterns
10 questions · ~5 min
Not started
Start
5
NULL Values
Medium
Learn how SQL treats missing values in comparisons, calculations and filters.
SQL · SQL Basics
#null#filtering
10 questions · ~6 min
Not started
Start
1
COUNT, SUM, AVG, MIN & MAX
Easy
Turn many rows into one number with the five core aggregate functions.
SQL · Aggregates & GROUP BY
#aggregates#select
10 questions · ~5 min
Not started
Start
2
GROUP BY
Medium
Split rows into groups and calculate a total, count or average for each one.
SQL · Aggregates & GROUP BY
#group-by#aggregates
10 questions · ~6 min
Not started
Start
3
HAVING
Medium
Filter groups by their totals, counts or averages after GROUP BY.
SQL · Aggregates & GROUP BY
#having#group-by
10 questions · ~6 min
Not started
Start
4
COUNT(*) vs COUNT(column)
Medium
Know exactly what each form of COUNT counts, and why NULL changes the answer.
SQL · Aggregates & GROUP BY
#aggregates#null
10 questions · ~6 min
Not started
Start
5
Aggregates & NULL
Medium
See how SUM, AVG, MIN and MAX skip NULL and what they return when nothing is left.
SQL · Aggregates & GROUP BY
#aggregates#null
10 questions · ~6 min
Not started
Start
1
INNER JOIN
Easy
Match rows from two tables with INNER JOIN and predict which rows come out.
SQL · SQL Joins
#joins#inner-join
10 questions · ~5 min
Not started
Start
2
LEFT JOIN
Medium
Keep every row of the left table with LEFT JOIN and handle the NULLs it creates.
SQL · SQL Joins
#joins#left-join
10 questions · ~6 min
Not started
Start
3
Self Join
Hard
Join a table to itself to read hierarchies, compare rows and find pairs.
SQL · SQL Joins
#joins#self-join
10 questions · ~8 min
Not started
Start
4
Join Pitfalls
Hard
Catch the join mistakes that silently duplicate rows, lose rows or inflate totals.
SQL · SQL Joins
#joins#gotchas
10 questions · ~8 min
Not started
Start
5
UNION & CROSS JOIN
Medium
Stack query results with UNION and UNION ALL and build every combination with CROSS JOIN.
SQL · SQL Joins
#union#joins
10 questions · ~6 min
Not started
Start
1
Subqueries
Medium
Put a query inside a query and predict what scalar, IN, derived-table and correlated subqueries return.
SQL · Subqueries & Window Functions
#subqueries#correlated-subqueries
10 questions · ~6 min
Not started
Start
2
EXISTS vs IN
Medium
Choose between EXISTS and IN, and avoid the NOT IN trap that returns nothing when a NULL sneaks in.
SQL · Subqueries & Window Functions
#subqueries#null-handling
10 questions · ~6 min
Not started
Start
3
Common Table Expressions (WITH)
Medium
Name intermediate results with WITH and generate rows or walk hierarchies with recursive CTEs.
SQL · Subqueries & Window Functions
#cte#recursive-cte
10 questions · ~6 min
Not started
Start
4
ROW_NUMBER, RANK & DENSE_RANK
Hard
Number and rank rows with window functions and know exactly how each one treats ties.
SQL · Subqueries & Window Functions
#window-functions#ranking
10 questions · ~8 min
Not started
Start
5
Running Totals, LAG & LEAD
Hard
Build running totals, moving averages and row-to-row comparisons with window frames, LAG and LEAD.
SQL · Subqueries & Window Functions
#window-functions#running-totals
10 questions · ~8 min
Not started
Start
1
INSERT, UPDATE & DELETE
Easy
Add, change and remove rows with INSERT, UPDATE and DELETE, and avoid the classic missing-WHERE mistake.
SQL · Changing Data & Database Design
#dml#crud
10 questions · ~5 min
Not started
Start
2
Constraints & Keys
Medium
Know what NOT NULL, UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY reject, and how SQLite, MySQL and PostgreSQL differ.
SQL · Changing Data & Database Design
#constraints#keys
10 questions · ~6 min
Not started
Start
3
Transactions & ACID
Medium
Group changes with BEGIN, COMMIT, ROLLBACK and savepoints, and know what each ACID property promises.
SQL · Changing Data & Database Design
#transactions#acid
10 questions · ~6 min
Not started
Start
4
Indexes
Medium
Learn what indexes speed up, what they cost and why some queries cannot use them.
SQL · Changing Data & Database Design
#indexes#performance
10 questions · ~6 min
Not started
Start
5
Normalization (1NF, 2NF, 3NF)
Medium
Spot tables that break 1NF, 2NF or 3NF, the anomalies they cause and how to split them.
SQL · Changing Data & Database Design
#design#normalization
10 questions · ~6 min
Not started
Start
1
Classic SQL Interview Queries
Hard
Solve the queries every SQL interview asks, like second highest salary, duplicates and top N per group.
SQL · SQL Interview Questions
#interview#queries
10 questions · ~8 min
Not started
Start
2
SQL Output Prediction
Medium
Read short SQL queries and predict their exact output, including the classic interview traps.
SQL · SQL Interview Questions
#output-prediction#gotchas
10 questions · ~6 min
Not started
Start
3
Tricky NULL Questions
Hard
Master the NULL traps interviewers love, from NOT IN and three-valued logic to aggregates and sorting.
SQL · SQL Interview Questions
#null#gotchas
10 questions · ~8 min
Not started
Start
4
Query Performance
Medium
Recognise slow query patterns and the rewrites that fix them, from N+1 queries to deep OFFSET pagination.
SQL · SQL Interview Questions
#performance#indexes
10 questions · ~6 min
Not started
Start
5
SQL: Find the Bug
Hard
Find the bugs in queries that run without errors but return the wrong answer, and in ones that do not run at all.
SQL · SQL Interview Questions
#debugging#interview
10 questions · ~8 min
Not started
Start
No quiz matches. Try another word or tag.