热情的悲伤蛙求求offer

分类

/ 注册

全部文章（共25篇）

题解 | 国庆期间每类视频点赞量和转发量

with a as( select tvi.tag, date(tuvl.start_time) as dt, tuvl.if_like, tuvl.if_retweet from tb_user_vi...

2025-05-09

0 12

题解 | 每个创作者每月的涨粉率及截止当前的总粉丝量

with a as( select tvi.author, date_format(tuvl.start_time,'%Y-%m') as dt, case when tuvl.if_follow=0 then 0 when tuvl.if_f...

2025-05-09

0 10

题解 | 每类视频近一个月的转发量/率

with a as( select tvi.tag, sum(tuvl.if_retweet) as retweet_cnt, round(sum(tuvl.if_retweet)/count(tuvl.video_id),3) as ret...

2025-05-09

0 12

题解 | 平均播放进度大于60%的视频类别

with a as( select tvi.tag, if(timestampdiff(second,tuvl.start_time,tuvl.end_time)/tvi.duration>=1,1,timestampdiff(second,tuvl.s...

2025-05-09

0 12

题解 | 各个视频的平均完播率

with a as( select tuvl.video_id, round(sum(if(timestampdiff(second,tuvl.start_time,tuvl.end_time)>=tvi.duration,1,0))/count(tuv...

2025-05-09

0 12

题解 | 某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级

with a as( select distinct answer_date, author_id from answer_tb ), b as ( select answer_date, a...

2025-05-09

0 13

题解 | 某乎问答回答过教育类问题的用户里有多少用户回答过职场类问题

with a as( select author_id from answer_tb as at left join issue_tb as it on it.issue_id = at.issue_id where ...

2025-05-09

0 13

题解 | 某乎问答单日回答问题数大于等于3个的所有用户

with a as( select answer_date, author_id, count(*) as answer_cnt from answer_tb group by answer_...

2025-05-09

0 7

题解 | 某乎问答高质量的回答中用户属于各级别的数量

with a as( select at.author_id, case when at.author_level between 1 and 2 then '1-2级' when at.author_level between 3 a...

2025-05-09

0 11

题解 | 某乎问答11月份日人均回答量

with a as( select answer_date, round(count(issue_id)/count(distinct author_id),2) as per_num from answer_tb grou...

2025-05-09

0 11