Easy
Date Functions
Orders After 2024-01-01
Return orders placed on or after 2024-01-01. Return columns: id, customer_id, order_date, total_amount. Order results by: order_date, id.
Preparing the interactive SQL workspace...
Challenge overview
What you will practice
Return orders placed on or after 2024-01-01. Return columns: id, customer_id, order_date, total_amount. Order results by: order_date, id.
- Difficulty
- Beginner
- SQL concept
- Date Functions
Public schema and sample data
customers
| id INTEGER | name TEXT | email TEXT | country TEXT | joined_date TEXT |
|---|---|---|---|---|
| 1 | Acme Corp | acme@corp.com | USA | 2020-01-15 |
| 2 | TechStart Ltd | ts@techstart.io | UK | 2020-03-22 |
| 3 | DataFlow Inc | info@dataflow.com | USA | 2021-06-10 |
products
| id INTEGER | name TEXT | category TEXT | price REAL | stock INTEGER |
|---|---|---|---|---|
| 1 | Analytics Dashboard | Software | 299 | 999 |
| 2 | Data Warehouse | Infrastructure | 1499 | 50 |
| 3 | ML Pipeline | Software | 799 | 999 |
orders
| id INTEGER | customer_id INTEGER | order_date TEXT | total_amount REAL | status TEXT |
|---|---|---|---|---|
| 1 | 1 | 2024-01-10 | 2697 | completed |
| 2 | 2 | 2024-01-15 | 799 | completed |
| 3 | 1 | 2024-02-01 | 1499 | completed |
order_items
| id INTEGER | order_id INTEGER | product_id INTEGER | quantity INTEGER | unit_price REAL |
|---|---|---|---|---|
| 1 | 1 | 1 | 3 | 299 |
| 2 | 1 | 4 | 8 | 99 |
| 3 | 2 | 3 | 1 | 799 |