会编程的发呆爱好者加麻加辣

分类

/ 注册

全部文章（共208篇）

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

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

2025-04-11

0 30

题解 | 统计快递运输时长

select e.exp_type, round(avg(timestampdiff(minute,ea.out_time,ea.in_time)/60),1) as time from express_tb e join exp_action_tb ea on e.exp_number = ea....

2025-04-11

0 23

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

select e.exp_number,e.exp_type,ec.claims_cost from express_tb e join exp_cost_tb ec on e.exp_number = ec.exp_number where ec.claims_cost is not null o...

2025-04-11

0 26

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

#求各类试卷平均成绩、用时 with a as( select ei.exam_id,ei.tag,avg(timestampdiff(second,er.start_time,er.submit_time)/60) as avg_time, avg(er.score) as avg_sc...

2025-04-11

0 28

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

select round(sum(s.sales_num*g.goods_price),3) as sales_total, round(sum(s.sales_num*g.goods_price)/count(distinct s.user_id),3) as per_trans from sal...

2025-04-11

0 25

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

select r.room_id,r.room_name, count(distinct u.user_id) as user_count from user_view_tb u join room_info_tb r on u.room_id = r.room_id where u.in_time...

2025-04-10

0 24

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

SELECT cid, pv, rk FROM ( SELECT c.cid, (COUNT(p.uid)-count(distinct p.uid))*1.000+1 AS pv, c.release_date, ROW...

2025-04-10

0 29

题解 | 查询成绩

select count(*) from (select s.sId,avg(SC.score) as avg_score from Student s join SC on s.sId=SC.sId group by s.sId)a where a.avg_score >60 因为本题...

2025-04-09

0 28

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

select sum(c.read_num )/sum(c.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 where a.fans_id ...

2025-04-09

0 23

题解 | 支付间隔平均值

select cast(avg(case when timestampdiff(second,o.logtime,s.logtime)>=0 then timestampdiff(second,o.logtime,s.logtime) else -timestampdiff(second,o....

2025-04-08

0 26