yyyy11一

分类

/ 注册

全部文章（共87篇）

题解 | 统计快递运输时长

select e.exp_type,round(avg(timestampdiff(MINUTE,out_time,in_time)/60),1) time from express_tb e join exp_action_tb ex on ex.exp_number=e.exp_number g...

2025-12-21

0 38

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

SELECT t.emp_id, i.emp_level, e.tag FROM exam_record t JOIN (SELECT exam_id, AVG(TIMESTAMPDIFF(SECOND, start_time, submit_time)) A...

2025-12-21

0 34

题解 | 支付间隔平均值

select CAST(avg(abs(timestampdiff(second,o.logtime,s.logtime))) AS UNSIGNED) as gap from order_log o inner join select_log s on o.order_id...

2025-12-20

0 36

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

SELECT e.log_day, u.user_id, u.hobby FROM (SELECT DATE(log_time) AS log_day, MIN(log_time) AS earliest_time FROM ...

2025-12-20

0 32

题解 | 查询连续登陆的用户

select user_id from (select *, date_sub(date(log_time),INTERVAL t1 day) t4 from (select *, row_number()over(partition by user_id order by log_time) t...

2025-12-18

0 42

题解 | 统计用户获得积分

select user_id, sum( floor( timestampdiff (minute, visit_time, leave_time) / 10 ) ) point from visit_tb gr...

2025-12-18

0 23

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

SELECT r.room_id, r.room_name, COUNT(DISTINCT u.user_id) AS user_count --避免同一用户多次进入同一直播间 FROM room_info_tb r INNER JOIN user_view_tb u ON r.roo...

2025-12-15

0 41

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

select t1.cid,t1.pv,t1.rk from (select p.cid, round(count(*)*1.0,3) pv,--转为浮点数并保留三位小数 row_number()over(order by count(*) desc,c.release_date desc) rk对...

2025-12-15

0 27

题解 | 统计各个部门平均薪资

select department,round(avg(normal_salary-dock_salary),3) avg_salary from staff_tb s join salary_tb s1 on s.staff_id=s1.staff_id where (normal_salary-...

2025-12-14

0 26

题解 | 更新用户积分信息？

SELECT t2.user_id, (t2.t1 +u.point) AS point FROM ( SELECT o.user_id, SUM(CASE WHEN o.order_price > 100 THEN o.order_price ELSE 0...

2025-12-14

0 51