题解 | #购买行为分析#
购买行为分析
https://www.nowcoder.com/practice/aece1723f85c4cbe95eaa87af1c94457
这是统计全表计算类的聚合函数,sum(求和),avg(平均值),max(最大值),min(最小值),count(计数)这几类很常用 计算前面distinct 去重计算，列多次出现，只算1次 select count(distinct 顾客ID) as "购买人数", sum(销售数量*零售价) as "销售金额", sum(销售数量*零售价)/count(distinct 顾客ID) as "客单价", sum(销售数量)/count(distinct 顾客ID) as "客单件", count(订单号)/count(distinct 顾客ID) as "人均购买频次" from 销售订单表
投递网易等公司10个岗位 >