2022-12-30 阅读量: 234
-- 2 数据预分析
select
count(distinct user_id) as 用户数,
count(distinct item_id) as 商品数,
count(distinct item_category) as 类目数
from UserBehavior_new;
select behavior_type,count(*) as 行为次数
from UserBehavior_new
group by behavior_type;
