SQL-complete-tutorial

1
SELECT 
2
	c.customer_id,
3
    c.first_name,
4
    o.order_id
5
FROM customers c
6
LEFT JOIN orders o
7
	ON c.customer_id = o.customer_id
8
ORDER BY c.customer_id;
9

10
-- Retrieve all products, whether or not ordered
11
SELECT 
12
	p.product_id,
13
    p.name,
14
    oi.quantity
15
FROM products p
16
LEFT JOIN order_items oi
17
	ON p.product_id = oi.product_id;