谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共88篇）

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

select er.emp_id, emp_level, tag as exam_tag from exam_record as er left join ( select exam_id, a...

2025-06-17

0 33

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

select sum(sales_num * goods_price) as sales_total, sum(sales_num * goods_price)/count(distinct user_id) as per_trans from sa...

2025-06-17

0 39

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

select a.room_id, rit.room_name, a.user_count from ( select room_id, count(distinct user_id) as user_count...

2025-06-15

0 32

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

select a.cid, a.pv, row_number() over(order by a.pv desc,cit.release_date desc ) as rk from ( select cid, ...

2025-06-15

0 32

题解 | 查询成绩

select count(*) from ( select sId from SC group by sId having avg(score) > 6...

2025-06-15

6 46

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

select sum(c.read_num) / sum(c.show_num) as fans_ctr from ( select b.content_id, a.fans_id from b lef...

2025-06-15

0 51

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

select id, name, weight, sum_count as total from ( select goods_id, sum(count) as sum_count fr...

2025-06-14

0 51

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

select music_name from ( select b.user_id, b.music_id from ( select user_id, ...

2025-06-14

0 45

题解 | 支付间隔平均值

select cast(avg(abs(timestampdiff(second,ol.logtime,sl.logtime))) as signed) as gap from order_log as ol left join ...

2025-06-14

0 30

题解 | 每天登陆最早的用户的内容喜好

select b.log_day, b.user_id, uatb.hobby from user_action_tb as uatb inner join ( select a.user_id, ...

2025-06-04

0 39