31

Recent Orders

EasyLIKEdates

Problem Description

Write a SQL query to get all orders placed in April 2023 (order_date starts with '2023-04').

Expected Columns

  • id
  • amount
  • order_date
  • status

Example Output

| id | amount | order_date | status | |----|--------|------------|--------| | 10 | 800.0 | 2023-04-01 | Delivered | | 11 | 27500.0 | 2023-04-10 | Delivered | | ... | ... | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#31 Recent Orders
Easy

Loading schema...

Loading editor...

No results yet

Run a query to see results