Deviopath

PostgreSQL coding challenges

  1. Every Product (Easy)
  2. Cheap Products (Easy)
  3. Rename the Columns (Easy)
  4. Value of the Stock (Easy)
  5. List of Categories (Easy)
  6. Well-Paid Sales and Support (Easy)
  7. Customers in Two Cities (Easy)
  8. Mid-Range Prices (Easy)
  9. Names Starting with A (Easy)
  10. Find the Lamps (Easy)
  11. Exams Not Graded Yet (Easy)
  12. Staff List by Department (Easy)
  13. Three Most Expensive (Easy)
  14. Page Two of the Catalog (Easy)
  15. Graded vs All Students (Easy)
  16. Revenue from Paid Orders (Easy)
  17. Average Salary (Easy)
  18. Cheapest and Priciest (Easy)
  19. Tidy Up the Text (Easy)
  20. Full Names (Easy)
  21. Fill In Missing Emails (Easy)
  22. Price Labels (Easy)
  23. Orders in March 2026 (Easy)
  24. Year of Hiring (Easy)
  25. Products per Category (Easy)
  26. Who Placed Each Order? (Easy)
  27. Add a Product (Easy)
  28. Restock Sold-Out Products (Easy)
  29. Remove Cancelled Orders (Easy)
  30. Create a Reviews Table (Easy)
  31. Busy Categories (Medium)
  32. Pricier Than Average (Medium)
  33. Customers Who Never Ordered (Medium)
  34. Readable Order Lines (Medium)
  35. One Contact List (Medium)
  36. Orders per Customer, Zeros Included (Medium)
  37. Who Is Your Manager? (Medium)
  38. Back Again in February (Medium)
  39. Members in Good Standing (Medium)
  40. Raise Prices and Report Back (Medium)
  41. Paid vs Pending (Medium)
  42. Big Spenders with a CTE (Medium)
  43. Monthly Revenue (Medium)
  44. Overdue Loans (Medium)
  45. Products in Each Order (Medium)
  46. Totals by Status, Side by Side (Medium)
  47. Clear Out Cancelled Items (Medium)
  48. Apply Scheduled Price Changes (Medium)
  49. Book In the Deliveries (Medium)
  50. A View of Customer Totals (Medium)
  51. Purchases from JSON Events (Medium)
  52. Popular Tags (Medium)
  53. Above Their Department Average (Medium)
  54. Latest Order per Customer (Medium)
  55. Top Two Earners per Department (Medium)
  56. RANK vs DENSE_RANK (Medium)
  57. Running Revenue Total (Medium)
  58. Day-over-Day Signups (Medium)
  59. Clean Up, Then Lock It Down (Medium)
  60. Every Day, Even the Quiet Ones (Medium)
  61. Share of Category Revenue (Hard)
  62. Second Highest Salary per Department (Hard)
  63. Top 2 Best Sellers per Category (Hard)
  64. Month-over-Month Growth (Hard)
  65. 7-Day Moving Average (Hard)
  66. Running Balance Goes Negative (Hard)
  67. Median Salary per Department (Hard)
  68. Score Histogram with Empty Buckets (Hard)
  69. Quartiles per Class (Hard)
  70. Remove Duplicate Subscribers (Hard)
  71. Overlapping Room Bookings (Hard)
  72. Frequently Bought Together (Hard)
  73. All Subcategories (Hard)
  74. Org Chart with Reporting Paths (Hard)
  75. Visit, Signup, Purchase Funnel (Hard)
  76. Longest Login Streak (Hard)
  77. Split Page Views into Sessions (Hard)
  78. Bill of Materials Cost (Hard)
  79. Monthly Cohort Retention (Hard)
  80. Customer RFM Report (Hard)
  81. Order Total With Tax (Hard)
  82. Shipping Cost Tiers (Hard)
  83. Generated Line Total (Hard)
  84. Priority as an Enum (Hard)
  85. Orders Between Two Dates (Hard)
  86. Latest Two Orders per Customer (Hard)
  87. Sales Report With Subtotals (Hard)
  88. Customer JSON Documents (Hard)
  89. Items Bought on iOS (Hard)
  90. Search Articles by Relevance (Hard)
  91. Rolling 7-Day Total (Hard)
  92. Materialized Daily Revenue (Hard)
  93. Upsert Page Counters (Hard)
  94. Booking Rules as Constraints (Hard)
  95. One Active Subscription per User (Hard)
  96. Sync a Product Feed With MERGE (Hard)
  97. Transfers With Savepoints (Hard)
  98. Keep updated_at Current (Hard)
  99. Audit Log for Balances (Hard)
  100. Stop Overselling (Hard)