Daily Revenue with Zero Days

medium
Unit 20 · Cohorts & Recursive CTEs0/1 to milestone

Return day and revenue for every date from the first order date to the last order date (inclusive), with 0 on days without orders. Sort by day.

Pro problem

Unlock this and every premium problem across all tracks — plus hidden-test grading, advanced AI engineering modules and new content every week.

Start 7-day free trial
query.sql · SQLite
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Daily Revenue with Zero Days · TechGradify