聚合函数
SELECT AVG(product.`id`) AS "avg_id",COUNT(product.`id`) AS "count_id",MAX(product.`id`) AS "max_id",MIN(product.`id`) AS "min_id",SUM(product.id) AS "sum_id" FROM product
AVG:求平均数
COUNT:求数量
MAX:求最大值
MIN:求最小值
SUM:求和
SELECT AVG(product.`id`) AS "avg_id",COUNT(product.`id`) AS "count_id",MAX(product.`id`) AS "max_id",MIN(product.`id`) AS "min_id",SUM(product.id) AS "sum_id" FROM product
AVG:求平均数
COUNT:求数量
MAX:求最大值
MIN:求最小值
SUM:求和