SQL-complete-tutorial

1
SELECT 
2
	client_id,
3
    SUM(invoice_total) AS total_sales
4
FROM invoices
5
GROUP BY client_id WITH ROLLUP;
6

7
SELECT 
8
	state,
9
    city,
10
    SUM(invoice_total) AS total_sales
11
FROM invoices i
12
JOIN clients c USING (client_id)
13
GROUP BY state, city WITH ROLLUP;
14

15
-- this option of ROLLUP is only available in mySQL (not in MS SQL, Oracle or similar)
16

17
SELECT
18
	pm.name AS payment_method,
19
	SUM(p.amount) AS total
20
FROM payments p
21
JOIN payment_methods pm 
22
	ON p.payment_method = pm.payment_method_id 
23
GROUP BY pm.name WITH ROLLUP;