MySQL-for-Data-Analytics/5.3 Aggregate Functions.sql at main · AnalystBuilder/MySQL-for-Data-Analytics · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
# Aggregate Functions


SELECT customer_id, SUM(tip) AS total_tips
FROM customer_orders
GROUP BY customer_id
;

SELECT customer_id, AVG(tip) AS average_tips
FROM customer_orders
GROUP BY customer_id
ORDER BY average_tips
;


SELECT customer_id, MAX(tip) AS biggest_tips
FROM customer_orders
GROUP BY customer_id
ORDER BY biggest_tips
;

SELECT customer_id, MIN(tip) AS smallest_tips
FROM customer_orders
GROUP BY customer_id
ORDER BY smallest_tips
;


SELECT customer_id, COUNT(tip) AS count_of_tips
FROM customer_orders
GROUP BY customer_id
ORDER BY count_of_tips
;

SELECT *
FROM customer_orders;


SELECT first_name, last_name, COUNT(phone)
FROM customers
GROUP BY first_name, last_name
;


SELECT product_id, tip, COUNT(tip), COUNT(DISTINCT tip)
FROM customer_orders
GROUP BY product_id, tip
ORDER BY product_id;