Orders in a Date Range

easy
Unit 8 · Filtering & Joins0/3 to milestone

Return the id, order_date and total of every order placed in February 2024 (both ends inclusive), sorted by order_date, then id.

Dates are stored as YYYY-MM-DD text, which sorts correctly as strings.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#filtering#dates1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Orders in a Date Range · TechGradify