SQL-complete-tutorial

1
USE sql_store;
2

3
SELECT 
4
	o.order_id,
5
    o.order_date,
6
    c.first_name,
7
    c.Last_name,
8
    os.name AS status
9
FROM orders o
10
JOIN customers c
11
	ON o.customer_id = c.customer_id
12
JOIN order_statuses os
13
	ON o.status = os.order_status_id;
14
    
15
-- In sql_invoicing database, join payment table with
16
-- clients and payment_methods table
17

18
USE sql_invoicing;
19

20
SELECT 
21
	c.client_id,
22
    c.name AS 'client name',
23
    p.invoice_id,
24
    p.date,
25
    p.amount,
26
    p.payment_method,
27
    pm.name AS 'payment type'
28
FROM payments p
29
JOIN clients c
30
	ON c.client_id = p.client_id
31
JOIN payment_methods pm
32
	ON pm.payment_method_id = p.payment_method;