谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共129篇）

题解 | 查询产生理赔费用的快递信息

select ect.exp_number, exp_type, claims_cost from exp_cost_tb as ect left join express_tb as et on ...

2025-06-17

0 25

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

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 38

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

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 47

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

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

题解 | 查询成绩

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

2025-06-15

7 51

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

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

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

2025-06-14

0 68

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

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

2025-06-14

0 53

题解 | 支付间隔平均值

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 37