Lateral

分类

/ 注册

全部文章（共115篇）

题解 | 淘宝店铺的实际销售额与客单价

select sum(s.sales_num*g.goods_price) as sales_total, sum(s.sales_num*g.goods_price)/count(distinct s.user_id) as per_trans from sales_tb s left join ...

2025-03-24

0 32

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

select u.room_id, r.room_name, count(distinct u.user_id) as user_count from user_view_tb u left join room_info_tb r on u.room_id...

2025-03-24

0 32

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

select t.cid, sum(t.pv) as pv, row_number() over(order by sum(t.pv) desc,c.release_date desc) as rk from (select p.cid, ...

2025-03-24

0 43

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

select t.cid, sum(t.pv) as pv, row_number() over(order by sum(t.pv) desc,c.release_date desc) as rk from (select p.cid, ...

2025-03-21

0 30

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

select t.cid, sum(t.pv) as pv, row_number() over(order by sum(t.pv) desc,c.release_date desc) as rk from (select p.cid, count(p.uid) as pv from play_r...

2025-03-21

0 32

题解 | 查询成绩

select count(*) from (select t1.sId from (select sId, case when cId=1 then score else 0 end as c1_score from SC) t1 left join (select sId, case...

2025-03-21

0 37

题解 | 请写出计算粉丝ctr的sql语句

select sum(c.read_num)/sum(c.show_num) as fans_ctr from c left join b on c.content_id=b.content_id left join a on b.author_id=a.author_id where c.fa...

2025-03-21

0 32

题解 | 商品交易(网易校招笔试真题)

select g.id, g.name, g.weight, sum(t.count) as total from trans t left join goods g on t.goods_id=g.id where g.weight<50 group by g.id having sum(t...

2025-03-21

0 51

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

select t2.music_name from (select m.id, m.music_name from (select distinct music_id from music_likes wher...

2025-03-21

0 55

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

select t2.music_name from (select m.id, m.music_name from (select distinct music_id from music_likes where user_id in(select follower_id ...

2025-03-21

0 53