题解 | 购买行为分析

select count(distinct 顾客ID) as 购买人数,
round(sum(销售数量*零售价)) as 销售金额,
sum(零售价*销售数量)/count(distinct 顾客ID) as 客单价,
round(sum(销售数量)/count(distinct 顾客ID)) as 客单件,
count(订单号)/count(distinct 顾客ID) as 人均购买频次
from 销售订单表