For orders 1 to 5, show one row per product in the order: order_id, the customer's
full_name, product_name and quantity.
End your query with ORDER BY order_id, product_name.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
| customers |
|---|
| customer_id (PK) |
| full_name |
| order_items |
|---|
| item_id (PK) |
| order_id (FK) |
| product_id (FK) |
| quantity |
| unit_price |
| discount_pct |
| products |
|---|
| product_id (PK) |
| product_name |
For orders 1 to 5, show one row per product in the order: order_id, the customer's
full_name, product_name and quantity.
End your query with ORDER BY order_id, product_name.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
| customers |
|---|
| customer_id (PK) |
| full_name |
| order_items |
|---|
| item_id (PK) |
| order_id (FK) |
| product_id (FK) |
| quantity |
| unit_price |
| discount_pct |
| products |
|---|
| product_id (PK) |
| product_name |
| order_id | full_name | product_name | quantity |
|---|---|---|---|
| 1 | Aisha Verma | Herbal Shampoo 650ml | 1 |
| 1 | Aisha Verma | Nova X5 Smartphone | 1 |
| 2 | Rahul Sharma | Classic White Sneakers | 2 |
| 2 | Rahul Sharma | Cold-Pressed Oil 1L | 2 |
| 3 | Neha Gupta | USB-C Fast Charger 65W | 1 |
| 3 | Neha Gupta | VoltBook Air 14 Laptop | 1 |
| 4 | Sanjay Mehta | Air Fryer 4.5L | 1 |
| 4 | Sanjay Mehta | Basmati Rice 5kg | 2 |
| 4 | Sanjay Mehta | Cold-Pressed Oil 1L | 1 |
| 5 | Amit Kumar | Cotton Kurta - Navy | 1 |
| 5 | Amit Kumar | Herbal Shampoo 650ml | 1 |
Run query to see output