SQL Window Functions problems
13 problems, easiest first.
- Daily Active Users with a 3-Day Averagewindow-functions · dates · aggregationmedium
- Deduplicate Marketing Leadsdeduplication · window-functions · stringsmedium
- Latest Status per Shipmentwindow-functions · deduplicationmedium
- Ledger Running Balancerunning-totals · window-functionsmedium
- Month-over-Month Revenuewindow-functions · dates · aggregationmedium
- Repeat Buyers Within 30 Dayswindow-functions · datesmedium
- Salary Share of Departmentwindow-functions · aggregationmedium
- Second-Highest Salary per Departmentranking · window-functionsmedium
- Top Two Products per Categorytop-n-per-group · window-functions · joinsmedium
- Customers Driving 80% of Revenuerunning-totals · window-functions · cteshard
- Longest Login Streakgaps-and-islands · window-functions · dateshard
- Median Delivery Days per Carrierwindow-functions · dates · aggregationhard
- Sessionize App Eventsgaps-and-islands · window-functions · dateshard