Orders in March 2025
Easy
Show the order_id of every order placed in March 2025.
Tables: customers(customer_id, name, city, country, joined) · products(product_id, name, category, price) · orders(order_id, customer_id, order_date, status) · order_items(order_id, product_id, quantity, unit_price)
Your query✔ Solved
Show the expected result
| order_id |
|---|
| 3 |
| 17 |
| 20 |
| 27 |
| 33 |
| 34 |
| 43 |
| 44 |
8 rows
Show a solution
SELECT order_id FROM orders WHERE order_date BETWEEN '2025-03-01' AND '2025-03-31';
SQL used
New to SQL? The free SQL course teaches everything these problems use, with a self-checking exercise in every lesson.