Orders with Product Details

Write a SQL query to list order items with product names and quantities.

Expected Columns

• order_id
• product_name
• quantity

Example Output

| order_id | product_name | quantity | |----------|--------------|----------| | 1 | Laptop Pro | 1 | | 1 | Wireless Mouse | 1 | | 2 | Office Chair | 1 | | ... | ... | ... |