Revenue by Day of the Week

easy
Unit 4 · Subqueries & Dates0/3 to milestone

When do customers buy? Return weekday (0 = Sunday … 6 = Saturday, as an integer), orders and revenue for each weekday that has orders, sorted by weekday.

Schema

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