SQL-complete-tutorial

1
SELECT 
2
	c.customer_id,
3
    c.first_name,
4
    o.order_id,
5
    sh.name AS shipper
6
FROM customers c
7
LEFT JOIN orders o
8
	ON c.customer_id = o.customer_id
9
LEFT JOIN shippers sh
10
	ON sh.shipper_id = o.shipper_id;
11
    
12
-- Return the data of order_date, order_id, first_name, shipper, status
13

14
SELECT 
15
	o.order_date,
16
    o.order_id,
17
    c.first_name AS customer,
18
    sh.name AS shipper,
19
    os.name AS status
20
FROM orders o
21
LEFT JOIN customers c
22
	ON c.customer_id = o.customer_id
23
LEFT JOIN shippers sh
24
	ON sh.shipper_id = o.shipper_id
25
LEFT JOIN order_statuses os
26
	ON os.order_status_id = o.status
27
ORDER BY status;