谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共81篇）

题解 | 统计快递从创建订单到发出间隔时长

select round(avg(timestampdiff(minute,create_time,out_time)) / 60 ,3) as time from express_tb as et left join exp_action_tb ...

2025-06-17

0 14

题解 | 统计快递运输时长

select exp_type, round(avg(timestampdiff(minute,out_time,in_time) / 60),1) as time from express_tb as et left join ...

2025-06-17

0 11

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

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 11

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

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 15

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

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 19

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

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

题解 | 查询成绩

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

2025-06-15

0 20

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

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

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

2025-06-14

0 15