Lateral

分类

/ 注册

全部文章（共146篇）

题解 | 完成员工考核试卷突出的非领导员工

select t4.emp_id, t4.emp_level, t4.tag as exam_tag from (select t1.emp_id, t2.emp_level, t3.tag, t1.exam_id, t1.submit_time-t1.start_tim...

2025-03-24

0 42

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

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 50

题解 | 短视频直播间晚上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 50

题解 | 被重复观看次数最多的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 58

题解 | 被重复观看次数最多的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 45

题解 | 被重复观看次数最多的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 45

题解 | 查询成绩

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 49

题解 | 请写出计算粉丝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 45

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

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 66

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

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

2025-03-21

0 79