Monthly Active Customers

easy
Unit 2 · Window Functions I0/3 to milestone

Return one row per month with month (YYYY-MM), active_customers (the number of distinct customers who ordered that month) and orders (the total number of orders). Sort by month.

Schema

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