AVG()函数返回数值列的平均值。
SQL AVG()语法
SELECT AVG(column_name) FROM table_name
演示数据库
示例
从"access_log"表的"count"列获取平均值:
SELECT AVG(count) AS CountAverage FROM access_log;
执行结果:
选择访问量高于平均访问量的"site_id"和"count":
SELECT site_id, count FROM access_log
WHERE count > (SELECT AVG(count) FROM access_log);
执行结果:
参考:
https://www.yuque.com/docs/share/a3b879c2-0df8-4d12-b03a-067c100d90ad