DataPlayArena

sql Practice Arena

Strengthen your sql development skills with interactive coding challenges running entirely in WebAssembly.

Difficulty:
#1. SELECT Basics - Product Inventory
Easy
Est. Time: 5 mins•
SQLEasy
#2. WHERE Filters - High-Value Orders
Easy
Est. Time: 5 mins•
SQLEasy
#3. DISTINCT - Unique Customer Cities
Easy
Est. Time: 5 mins•
SQLEasy
#4. ORDER BY - Sorting Employee Salaries
Easy
Est. Time: 5 mins•
SQLEasy
#5. LIMIT & TOP - Highest Priced Product
Easy
Est. Time: 5 mins•
SQLEasy
#6. BETWEEN Range
Easy
Est. Time: 5 mins•
SQLEasy
#7. IN operator
Easy
Est. Time: 5 mins•
SQLEasy
#8. LIKE wildcards
Easy
Est. Time: 5 mins•
SQLEasy
#9. IS NULL check
Easy
Est. Time: 5 mins•
SQLEasy
#10. COUNT Aggregation
Easy
Est. Time: 5 mins•
SQLEasy
#11. SUM Aggregation
Easy
Est. Time: 5 mins•
SQLEasy
#12. AVG Aggregation
Easy
Est. Time: 5 mins•
SQLEasy
#13. MIN & MAX
Easy
Est. Time: 5 mins•
SQLEasy
#14. CASE Conditional
Easy
Est. Time: 5 mins•
SQLEasy
#15. CONCAT String
Easy
Est. Time: 5 mins•
SQLEasy
#16. SUBSTRING Extraction
Easy
Est. Time: 5 mins•
SQLEasy
#17. LENGTH filter
Easy
Est. Time: 5 mins•
SQLEasy
#18. Casing Functions
Easy
Est. Time: 5 mins•
SQLEasy
#19. ROUND function
Easy
Est. Time: 5 mins•
SQLEasy
#20. Date Formatting
Easy
Est. Time: 5 mins•
SQLEasy
#21. Simple GROUP BY
Easy
Est. Time: 5 mins•
SQLEasy
#22. HAVING Filter
Easy
Est. Time: 5 mins•
SQLEasy
#23. Column Aliases
Easy
Est. Time: 5 mins•
SQLEasy
#24. COALESCE Nulls
Easy
Est. Time: 5 mins•
SQLEasy
#25. Basic Join
Easy
Est. Time: 5 mins•
SQLEasy
#26. INNER JOIN - Employee Department Names
Medium
Est. Time: 5 mins•
SQLMedium
#27. LEFT JOIN - Customers Who Never Order (LeetCode 183)
Medium
Est. Time: 5 mins•
SQLMedium
#28. RIGHT JOIN Equivalent
Medium
Est. Time: 5 mins•
SQLMedium
#29. SELF JOIN Managers
Medium
Est. Time: 5 mins•
SQLMedium
#30. CROSS JOIN Matrix
Medium
Est. Time: 5 mins•
SQLMedium
#31. UNION Operators
Medium
Est. Time: 5 mins•
SQLMedium
#32. UNION ALL
Medium
Est. Time: 5 mins•
SQLMedium
#33. Subqueries in WHERE
Medium
Est. Time: 5 mins•
SQLMedium
#34. EXISTS checks
Medium
Est. Time: 5 mins•
SQLMedium
#35. NOT EXISTS checks
Medium
Est. Time: 5 mins•
SQLMedium
#36. Common Table Expressions
Medium
Est. Time: 5 mins•
SQLMedium
#37. Window ROW_NUMBER
Medium
Est. Time: 5 mins•
SQLMedium
#38. Window RANK
Medium
Est. Time: 5 mins•
SQLMedium
#39. Window DENSE_RANK
Medium
Est. Time: 5 mins•
SQLMedium
#40. Window LAG
Medium
Est. Time: 5 mins•
SQLMedium
#41. Window LEAD
Medium
Est. Time: 5 mins•
SQLMedium
#42. Running Total
Medium
Est. Time: 5 mins•
SQLMedium
#43. Top N per Group
Medium
Est. Time: 5 mins•
SQLMedium
#44. Duplicate Detection
Medium
Est. Time: 5 mins•
SQLMedium
#45. Distinct Deduplication
Medium
Est. Time: 5 mins•
SQLMedium
#46. Customer Revenue
Medium
Est. Time: 5 mins•
SQLMedium
#47. Monthly Sales
Medium
Est. Time: 5 mins•
SQLMedium
#48. JSON Parsing
Medium
Est. Time: 5 mins•
SQLMedium
#49. Pivot Sums
Medium
Est. Time: 5 mins•
SQLMedium
#50. Full Merge simulation
Medium
Est. Time: 5 mins•
SQLMedium
#51. Subquery & Joins - Department Highest Salary (LeetCode 184)
Hard
Est. Time: 5 mins•
SQLHard
#52. Window DENSE_RANK - Department Top Three Salaries (LeetCode 185)
Hard
Est. Time: 5 mins•
SQLHard
#53. Sessionization Clickstream
Hard
Est. Time: 5 mins•
SQLHard
#54. Gap and Islands
Hard
Est. Time: 5 mins•
SQLHard
#55. SCD Type 2 lookup
Hard
Est. Time: 5 mins•
SQLHard
#56. Incremental Load Filter
Hard
Est. Time: 5 mins•
SQLHard
#57. Data Quality audit
Hard
Est. Time: 5 mins•
SQLHard
#58. Cohort Signups
Hard
Est. Time: 5 mins•
SQLHard
#59. Sales Dashboard aggregates
Hard
Est. Time: 5 mins•
SQLHard
#60. ETL Pipeline staging
Hard
Est. Time: 5 mins•
SQLHard