Sheets
Comprehensive collection of the most frequently asked SQL query interview questions. Covers SELECT operations, JOINs, subqueries, aggregations, window functions, and complex real-world scenarios. Each query is production-ready and commonly asked in technical interviews at top companies.
0%
0/110
Overall progress
0 / 110
0/30
Easy
0/40
Medium
0/40
Hard
| Status | Problem | Guide | Article | Solve | Revision | Level | |
|---|---|---|---|---|---|---|---|
| 1. |  |  | Easy | ||||
| 2. | | | Easy | ||||
| 3. | | | Easy | ||||
| 4. | | | Easy | ||||
| 5. | | | Easy | ||||
| 6. | | | Easy | ||||
| 7. | | | Easy | ||||
| 8. | | | Easy | ||||
| 9. | | | Easy | ||||
| 10. | | | Easy | ||||
| 11. | | | Easy | ||||
| 12. | | | Easy | ||||
| 13. | | | Easy | ||||
| 14. | | | Easy | ||||
| 15. | | | Easy | ||||
| 16. | | | Easy | ||||
| 17. | | | Easy | ||||
| 18. | | | Easy | ||||
| 19. | | | Easy | ||||
| 20. | | | Easy | ||||
| 21. | | | Easy | ||||
| 22. | | | Easy | ||||
| 23. | | | Easy | ||||
| 24. | | | Easy | ||||
| 25. | | | Easy | ||||
| 26. | | | Easy | ||||
| 27. | | | Easy | ||||
| 28. | | | Easy | ||||
| 29. | | | Easy | ||||
| 30. | | | Easy | ||||
| 31. | | | Medium | ||||
| 32. | | | Medium | ||||
| 33. | | | Medium | ||||
| 34. | | | Medium | ||||
| 35. | | | Medium | ||||
| 36. | | | Medium | ||||
| 37. | | | Medium | ||||
| 38. | | | Medium | ||||
| 39. | | | Medium | ||||
| 40. | | | Medium | ||||
| 41. | | | Medium | ||||
| 42. | | | Medium | ||||
| 43. | | | Medium | ||||
| 44. | | | Medium | ||||
| 45. | | | Medium | ||||
| 46. | | | Medium | ||||
| 47. | | | Medium | ||||
| 48. | | | Medium | ||||
| 49. | | | Medium | ||||
| 50. | | | Medium | ||||
| 51. | | | Medium | ||||
| 52. | | | Medium | ||||
| 53. | | | Medium | ||||
| 54. | | | Medium | ||||
| 55. | | | Medium | ||||
| 56. | | | Medium | ||||
| 57. | | | Medium | ||||
| 58. | | | Medium | ||||
| 59. | | | Medium | ||||
| 60. | | | Medium | ||||
| 61. | | | Medium | ||||
| 62. | | | Medium | ||||
| 63. | | | Medium | ||||
| 64. | | | Medium | ||||
| 65. | | | Medium | ||||
| 66. | | | Medium | ||||
| 67. | | | Medium | ||||
| 68. | | | Medium | ||||
| 69. | | | Medium | ||||
| 70. | | | Medium | ||||
| 71. | | | Hard | ||||
| 72. | | | Hard | ||||
| 73. | | | Hard | ||||
| 74. | | | Hard | ||||
| 75. | | | Hard | ||||
| 76. | | | Hard | ||||
| 77. | | | Hard | ||||
| 78. | | | Hard | ||||
| 79. | | | Hard | ||||
| 80. | | | Hard | ||||
| 81. | | | Hard | ||||
| 82. | | | Hard | ||||
| 83. | | | Hard | ||||
| 84. | | | Hard | ||||
| 85. | | | Hard | ||||
| 86. | | | Hard | ||||
| 87. | | | Hard | ||||
| 88. | | | Hard | ||||
| 89. | | | Hard | ||||
| 90. | | | Hard | ||||
| 91. | | | Hard | ||||
| 92. | | | Hard | ||||
| 93. | | | Hard | ||||
| 94. | | | Hard | ||||
| 95. | | | Hard | ||||
| 96. | | | Hard | ||||
| 97. | | | Hard | ||||
| 98. | | | Hard | ||||
| 99. | | | Hard | ||||
| 100. | | | Hard | ||||
| 101. | | | Hard | ||||
| 102. | | | Hard | ||||
| 103. | | | Hard | ||||
| 104. | | | Hard | ||||
| 105. | | | Hard | ||||
| 106. | | | Hard | ||||
| 107. | | | Hard | ||||
| 108. | | | Hard | ||||
| 109. | | | Hard | ||||
| 110. | | | Hard |
Overwhelmingly: SELECT and filtering, JOINs of every kind, GROUP BY with aggregations, subqueries, CTEs and window functions. Window functions and the analytics patterns built on them — running totals, rankings, gaps and islands — are what separate an intermediate answer from a strong one, and they are the most common gap.
Coverage matters more than volume. The 110 queries on this sheet span every category that comes up, and working through them once with the solutions read properly is worth more than several hundred repetitions of basic SELECT statements.
For backend, data and analytics roles, yes, and often as a dedicated round. For frontend and mobile roles it is usually lighter but still appears, most often as basic JOINs and aggregation. Data roles go deepest — expect window functions and query optimisation.
The SQL round asks you to write queries. The DBMS round asks theory — normalisation, indexing, ACID properties, transactions and isolation levels. They are usually separate and both come up, so prepare the theory alongside the queries.
Yes. Every query, its worked solution, the written guides and the progress tracking are free with no account required. Progress saves in your browser; signing in only adds syncing across devices.