牛客489527393号

分类

/ 注册

TA的专栏 15篇文章 0人订阅

从0开始的SQL之旅

15篇文章 79人学习

全部文章（共17篇）

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

select tag, sum(if_retweet) as retweet_cnt, round(avg(if_retweet),3) as retweet_rate from(select tag, if_retweet from tb_user_video_log join tb_video_...

2025-02-20

0 63

题解 | 商品销售总额分布来自专栏

select pay_method, count(*) as cnt from( select if(pay_method ='','error',pay_method)pay_method from user_client_log join product_info ...

2025-02-19

1 59

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数来自专栏

select room_id, max(room_name), count(distinct user_id) as user_count from user_view_tb join room_info_tb using(room_id) where out_time>='23:00:00'...

2025-02-18

3 63

题解 | 被重复观看次数最多的3个视频来自专栏

select cid, max(pv1) as pv, row_number() over(order by max(pv1) desc,max(release_date) desc) as rk from( select uid, ...

2025-02-18

0 79

题解 | 查询成绩来自专栏

select count(*) from ( select sid, sum(score)/COUNT(1) as s -- 不能聚合套聚合 from SC where cid in (select cid from Course where cname in ('语文',...

2025-02-18

0 70

题解 | 请写出计算粉丝ctr的sql语句来自专栏

select sum(read_num)/sum(show_num) as fans_ctr from c join b using(content_id) where (fans_id,author_id) in (select fans_id,author_id from a)

2025-02-18

0 70

题解 | 网易云音乐推荐(网易校招笔试真题) 来自专栏

select music_name FROM( select music_name, m.id from music m join music_likes ml on m.id = ml.music_id where user_id in (selec...

2025-02-18

0 66