Sql Labs
Practice
Playground
Run
Ctrl+
Submit
Questions
1. Select All Users
Easy
SELECT
2. Filter Users by Age
Easy
SELECT
WHERE
3. Count Users by City
Medium
COUNT
GROUP BY
4. Find Youngest User
Easy
SELECT
ORDER BY
LIMIT
5. Second Highest Salary
Medium
SELECT
SUBQUERY
MAX
6. Duplicate Emails
Easy
GROUP BY
HAVING
COUNT
7. Employees Earning More Than Managers
Medium
SELF JOIN
8. Customers Who Never Order
Easy
LEFT JOIN
IS NULL
9. Rising Temperature
Medium
SELF JOIN
DATE
10. Rank Scores
Medium
WINDOW FUNCTION
DENSE_RANK
11. Consecutive Numbers
Medium
SELF JOIN
12. Department Highest Salary
Medium
JOIN
SUBQUERY
GROUP BY
13. Exchange Seats
Medium
CASE
MOD
14. Classes With 5+ Students
Easy
GROUP BY
HAVING
15. Combine Two Tables
Easy
LEFT JOIN
16. Average Order Value
Easy
AVG
JOIN
17. Products Never Sold
Easy
LEFT JOIN
IS NULL
18. Top Selling Products
Medium
JOIN
GROUP BY
ORDER BY
19. User Login Streak
Hard
WINDOW FUNCTION
20. Monthly Revenue
Medium
GROUP BY
SUM
strftime
21. Active Users
Easy
COUNT
DISTINCT
WHERE
22. Employee Hierarchy
Hard
SELF JOIN
RECURSIVE
23. Order Status Summary
Medium
CASE
GROUP BY
COUNT
24. Running Total
Medium
WINDOW FUNCTION
SUM
25. Nth Order Per Customer
Hard
WINDOW FUNCTION
ROW_NUMBER
26. Query Challenge 26
Hard
SELECT
WHERE
27. Query Challenge 27
Easy
SELECT
WHERE
28. Query Challenge 28
Medium
SELECT
WHERE
29. Query Challenge 29
Hard
SELECT
WHERE
30. Query Challenge 30
Easy
SELECT
WHERE
31. Query Challenge 31
Medium
SELECT
WHERE
32. Query Challenge 32
Hard
SELECT
WHERE
33. Query Challenge 33
Easy
SELECT
WHERE
34. Query Challenge 34
Medium
SELECT
WHERE
35. Query Challenge 35
Hard
SELECT
WHERE
36. Query Challenge 36
Easy
SELECT
WHERE
37. Query Challenge 37
Medium
SELECT
WHERE
38. Query Challenge 38
Hard
SELECT
WHERE
39. Query Challenge 39
Easy
SELECT
WHERE
40. Query Challenge 40
Medium
SELECT
WHERE
41. Query Challenge 41
Hard
SELECT
WHERE
42. Query Challenge 42
Easy
SELECT
WHERE
43. Query Challenge 43
Medium
SELECT
WHERE
44. Query Challenge 44
Hard
SELECT
WHERE
45. Query Challenge 45
Easy
SELECT
WHERE
46. Query Challenge 46
Medium
SELECT
WHERE
47. Query Challenge 47
Hard
SELECT
WHERE
48. Query Challenge 48
Easy
SELECT
WHERE
49. Query Challenge 49
Medium
SELECT
WHERE
50. Query Challenge 50
Hard
SELECT
WHERE
Select a question
Loading...
Test Results
Console
Ready to Run
Execute your query to see the results here.