Signups by Day of the Week

easy
Unit 5 · Dates & Set Operations0/3 to milestone

Return weekday (0 = Sunday ... 6 = Saturday, as an integer), day_name (Sun, Mon, ...) and signups for weekdays that have signups, 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
Signups by Day of the Week · TechGradify