2022-12-30
閱讀量:
651
mysql 學(xué)習(xí)43--數(shù)據(jù)預(yù)分析
-- 2 數(shù)據(jù)預(yù)分析
select
count(distinct user_id) as 用戶數(shù),
count(distinct item_id) as 商品數(shù),
count(distinct item_category) as 類目數(shù)
from UserBehavior_new;
select behavior_type,count(*) as 行為次數(shù)
from UserBehavior_new
group by behavior_type;






評論(0)


暫無數(shù)據(jù)
推薦帖子
0條評論
1條評論
0條評論