2022-12-30 阅读量: 187
-- 3.1.3 练习:每小时PV、UV、人均浏览量、成交量、成交额
select
小时,
sum(behavior_type='pv') as 浏览量,
count(distinct user_id) as 访客数,
sum(behavior_type='pv')/count(distinct user_id) as 人均浏览量,
sum(behavior_type='buy') as 成交量,
sum(if(behavior_type='buy',amount,0)) as 成交额
from UserBehavior_new
group by 小时;
