PostgreSQL提供了AVG()函数来计算集合的平均值。 AVG()函数是PostgreSQL中最常用的聚合函数之一。 AVG()函数使用户能够计算数字列的平均值。
用法: AVG(column)
它可以与SELECT和HAVING子句一起使用。现在来看一些示例。
在此示例中,我们将使用AVG()函数查询以了解客户支付的平均数量。
SELECT EXTRACT(isodow from countdate) as week, hour, avg(innum) as innum FROM d_mall_hour_count_data WHERE countdate BETWEEN '20230301' AND '20230331'
GROUP BY week,hour
ORDER BY week, hour;
执行结果
SELECT EXTRACT(isodow from countdate) as week, hour, to_char (AVG(innum) ,'99999999999999999D99')
as innum FROM d_mall_hour_count_data WHERE countdate BETWEEN '20230301' AND '20230331'
GROUP BY week,hour
ORDER BY week, hour;
执行结果