讨厌吃香菜的小山竹在写文章

分类

/ 注册

全部文章（共27篇）

题解 | #近一个月发布的视频中热度最高的top3视频#

佬们请帮我看看这是错哪儿了？结果不对。只有最高热度的是对的。 select video_id ,round((100*cmp_rt + 5*like_cnt + 3*comment_cnt + 2*retweet_cnt)*new_du) as hot_index from ( select...

2024-06-18

0 151

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

select tag ,concat(round(avg(play_progress)*100, 2), '%') as avg_play_progress from ( select info.tag ,case when timestampdiff(second, l...

2024-06-18

0 161

题解 | #查询职位发布时间在2021年后或职位城市为上海的

select job_id ,boss_id ,company_id from ( select job_id ,boss_id ,company_id ,job_city from job_info where year(post_time...

2024-06-17

0 173

题解 | #查询每个公司查看过的投递用户数#

select b.company_id ,sum(if(a.resume_if_checked = 1, 1, 0)) as cnt from deliver_record a left join job_info b on a.job_id = b.job_id group by company...

2024-06-17

0 170

题解 | 查询2022年以来刷题用户的用user_id

select a.user_id ,b.university from questions_pass_record a left join user_info b on a.user_id = b.user_id where a.date >= '2022-01-01'

2024-06-17

0 160

题解 | #统计每天刷题数超过5的user_id以及刷题数#

select date ,user_id ,sum(pass_count) as total_pass_count from questions_pass_record_detail group by user_id, date having total_pass_count > 5

2024-06-17

0 154

题解 | #浙大不同难度题目的正确率#

select c.difficult_level as difficult_level ,round(sum(if(a.result = 'right',1 ,0)) / count(a.device_id), 4) as correct_rate from question_practice_d...

2024-06-17

0 129

题解 | #统计复旦用户8月练题情况#

select a.device_id ,b.university ,count(a.question_id) as question_cnt ,sum(if(a.result = 'right', 1, 0)) as right_question_cnt from question_practice...

2024-06-17

0 148

题解 | #统计复旦用户8月练题情况#

select up.device_id ,'复旦大学' as university ,count(question_id) as question_cnt ,sum(if(qpd.result='right', 1, 0)) as right_question_cnt from user_prof...

2024-06-17

0 169

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

with tmp as( select device_id ,date from question_practice_detail group by device_id, date ) select count(b.device_id) / count(...

2024-06-17

0 136