Customer issues are piling up at Shopify, and the fulfillment team needs the most recent orders pulled immediately. Using the orders table, return the 10 most recent orders (all columns), ordered by order_date descending.
orders
| column | type |
|---|---|
| id | INTEGER |
| customer_name | TEXT |
| total | NUMERIC |
| order_date | DATE |
| id | customer_name | total | order_date |
|---|---|---|---|
| 1 | Alice | 120.00 | 2024-01-15 |
| 2 | Bob | 45.50 | 2024-03-02 |
| 3 | Carol | 210.00 | 2023-11-30 |
| 4 | Dave | 75.00 | 2024-02-14 |
| 5 | Eve | 330.00 | 2024-03-10 |
| id | customer_name | total | order_date |
|---|---|---|---|
| 5 | Eve | 330.00 | 2024-03-10 |
| 2 | Bob | 45.50 | 2024-03-02 |
| 4 | Dave | 75.00 | 2024-02-14 |
| 1 | Alice | 120.00 | 2024-01-15 |
| 3 | Carol | 210.00 | 2023-11-30 |
Orders are sorted by order_date descending so the most recent appears first. With only 5 orders in this example, all are returned since the count is below the LIMIT 10 threshold.