Multi-Table Join with Quantities

Easy
joins Uber Stripe LinkedIn

Write a query joining orders, order_items, and products to show each order item with the order date and product name. Return order_id, order_date, product_name, and quantity, ordered by order_id, then product_name.

Expected Output: Order items with their order date and product details.

Tables

Hints (2 available)

SQL Editor

Output

Click "Run" to see results...