最爱青草蛋糕

分类

/ 注册

全部文章（共74篇）

题解 | 最长连续登录天数

select user_id,max(title_number) as max_consec_days from ( select user_id,title,count(*) as title_number from ( select user_id,fdate,date_sub(fdate,in...

2025-07-30

0 29

题解 | 每个月Top3的周杰伦歌曲

select month,ranking,song_name,play_pv from( select month, row_number()over(partition by month order by play_pv desc,songid asc) as ranking, song_name...

2025-07-30

0 29

题解 | 计算用户的平均次日留存率

select(select count(date_add_1day) from(select table1.device_id,date_add_1day from (select device_id,date from question_practice_detailgroup by device...

2025-07-22

0 24

题解 | 统计每个学校的答过题的用户的平均答题数

select uni as university,round(count(que)/count(distinct dev),4) as avg_answer_cnt from ( select u.device_id as dev,u.university as uni,question_id as...

2025-07-17

0 40