Revenue by Quarter

easy
Checkpoint challenge
Solve this to show you know the material and jump straight to Unit 3. Everything before it counts as cleared.

Return quarter (as text like 2024-Q1) and revenue (sum of order totals), one row per quarter that has orders, sorted by quarter.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#aggregation#dates2 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Revenue by Quarter · TechGradify