Skip to content
CodeItRaw

At midnight a confidential file leaked. You have the door logs, file access and VPN logins: find the culprit with your queries.

  1. 01The trailEasy
  2. 02Working lateMedium
  3. 03The server roomMedium
  4. 04From outsideMedium
  5. 05SuspectsHard
  6. 06The culpritHard

Practice

Every task outside the story, easy to hard: over a company's staff and an online shop's orders. Each one teaches a different part of SQL.

0/57
  1. First queryEasy
  2. FilterEasy
  3. Several conditionsEasy
  4. Top three salariesEasy
  5. Starts with a letterEasy
  6. Missing valuesEasy
  7. Team leadsEasy
  8. How many?Easy
  9. Per departmentEasy
  10. Average salaryEasy
  11. No repeatsEasy
  12. A rangeEasy
  13. A computed columnEasy
  14. Sort by two keysEasy
  15. All but theseEasy
  16. Page twoEasy
  17. Cheapest and dearestEasy
  18. Join textEasy
  19. In place of nothingEasy
  20. March ordersEasy
  21. Busy departmentsMedium
  22. Monthly salesMedium
  23. Top sellerMedium
  24. Join tablesMedium
  25. Nobody left outMedium
  26. ManagersMedium
  27. The Orion teamMedium
  28. No projectMedium
  29. Project hoursMedium
  30. Above averageMedium
  31. The sales cityMedium
  32. SellersMedium
  33. Label themMedium
  34. The weekendMedium
  35. Group by two columnsMedium
  36. Conditional countsMedium
  37. How many different customers?Medium
  38. Basket totalMedium
  39. Sold but never reviewedMedium
  40. A score you can trustMedium
  41. What per cent?Medium
  42. Top of each departmentHard
  43. Above the department averageHard
  44. Rank within departmentHard
  45. Running totalHard
  46. Month over monthHard
  47. Top two per departmentHard
  48. Same cityHard
  49. Above-average spendersHard
  50. Where the condition belongsHard
  51. Days to the first orderHard
  52. Moving averageHard
  53. Share of revenueHard
  54. The same againHard
  55. From every aisleHard
  56. Bought togetherHard
  57. QuartersHard

To learn SQL step by step, see the SQL topics on the Path.