SQL Dates problems
16 problems, easiest first.
- Late Shipmentsdates · select-filter · sortingeasy
- Monthly Signup Countsdates · group-byeasy
- Cumulative Hires by Yearrunning-totals · dates · group-bymedium
- Daily Active Users with a 3-Day Averagewindow-functions · dates · aggregationmedium
- Month-over-Month Revenuewindow-functions · dates · aggregationmedium
- Orders by Day of Weekdates · case-when · group-bymedium
- Quarterly Sales Pivotpivot · case-when · datesmedium
- Repeat Buyers Within 30 Dayswindow-functions · datesmedium
- Ticket First Response Timejoins · dates · null-handlingmedium
- Daily Revenue with Missing Days Filledrecursive-cte · dates · running-totalshard
- Longest Login Streakgaps-and-islands · window-functions · dateshard
- Median Delivery Days per Carrierwindow-functions · dates · aggregationhard
- Next-Month Retention by Signup Cohortctes · dates · subquerieshard
- Overlapping Driver Deliveriesself-join · dateshard
- Price Effective at Order Timesubqueries · dates · joinshard
- Sessionize App Eventsgaps-and-islands · window-functions · dateshard