存几分期许

分类

/ 注册

全部文章（共167篇）

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

select round(avg(timestampdiff(minute, create_time, out_time)/60), 3) as time from express_tb a join exp_action_tb b on a.exp_number=b.exp_number

2025-08-08

0 42

题解 | 统计快递运输时长

select exp_type, round(avg(timestampdiff(second, out_time, in_time)/60/60), 1) as time from express_tb a join exp_action_tb b on a.exp_number=b.exp_n...

2025-08-08

0 45

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

select a.exp_number, exp_type, claims_cost from express_tb a join exp_cost_tb b on a.exp_number=b.exp_number where claims_cost is not null order by cl...

2025-08-08

0 49

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

with t_avg_time as ( select exam_id, avg(timestampdiff(second, start_time, submit_time)) as avg_time from exam_record group by exam_id ), ...

2025-08-08

0 34

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

select sum(sales_total), round(sum(sales_total)/user_num, 3) as per_trans from ( select goods_price*sales_num as sales_total, (select count(di...

2025-08-08

0 41

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

select a.room_id, room_name, count(distinct user_id) as user_count from user_view_tb a join room_info_tb b on a.room_id=b.room_id where in_time<='2...

2025-08-08

0 45

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

select cid, pv, row_number() over (order by pv desc, release_date desc) as rk from ( select a.cid, cast(count(1) as float) as pv, release_date ...

2025-08-08

0 33

题解 | 查询成绩

WITH t AS ( SELECT stu.sId FROM Student stu JOIN (SELECT sId, cId, score FROM SC GROUP BY sId, cId, score) sc ON stu.sId = sc.sId JOIN...

2025-08-08

0 37

题解 | 查询成绩

with t as ( select stu.sId from Student stu join ( select sId, cId, score from SC group by sId, cId, score ) s...

2025-08-08

0 27

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

select sum(read_num)/sum(show_num) as fans_ctr from a join b on a.author_id=b.author_id join c on b.content_id=c.content_id and a.fans_id=c.fans_id

2025-08-08

0 21