《MySQL必知必会》第十二章-汇总数据

聚集函数（aggregate function）：
对某些行运行的函数，计算并返回一个值。

AVG（）函数：
SELECT AVG(prod_price) AS avg_price
FROM Products
WHERE vend_id = 'DLL01';

COUNT（）函数：
SELECT COUNT(*) AS num_cust  -- 不忽略NULL值
FROM Customers;

SELECT COUNT(cust_email) AS num_cust  -- 忽略NULL值
FROM Customers;

MAX（）函数：
SELECT MAX(prod_price) AS max_price
FROM Products;

MIN（）函数

SUM（）函数：
SELECT SUM(quantity) AS items_ordered
FROM OrderItems
WHERE order_num = 20005;

SELECT SUM(item_price*quantity) AS total_price
FROM OrderItems
WHERE order_num = 20005;

聚集不同值：
SELECT AVG(DISTINCT prod_price) AS avg_price
FROM Products
WHERE vend_id = 'DLL01'

组合聚集函数：
SELECT COUNT(*) AS num_items,
    MIN(prod_price) AS price_min,
    MAX(prod_price) AS price_max,
    AVG(prod_price) AS price_avg
FROM Products;