重生之各大厂争着抢我

分类

/ 注册

全部文章（共48篇）

题解 | 支付间隔平均值

select cast(avg(abs(timestampdiff(second,o.logtime,s.logtime))) as unsigned ) as gap from order_log o join select_log s using(order_id);

2026-01-08

0 49

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

with min_tb as( select min(log_time) as mintime, date(log_time) as log_day from login_tb group by date(log_time) ), e_user as( sel...

2026-01-08

0 44

题解 | 统计加班员工占比

select department, concat(round(sum(case when time>9.5 then 1 else 0 end)*1.0/count(*)*100,1),'%') as ratio from (select staff_id, timestam...

2026-01-08

0 32

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

select department, round(avg(salary),3) as avg_salary from ( select staff_id,normal_salary-dock_salary as salary from salary_tb where ...

2026-01-08

0 53

题解 | 查询单日多次下订单的用户信息？

with a as( select user_id, date(order_time) as order_date, count(*) as order_nums from order_tb group by user_id,date(orde...

2026-01-08

0 46

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

select user_id, point+sum(order_price) as point from (select * from order_tb where order_price>100) o join uservip_tb using(user_id) gr...

2026-01-08

0 49

题解 | 统计用户获得积分

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

2026-01-08

0 37

题解 | 统计用户从访问到下单的转化率

with a as( select date(order_time) as ot,count(distinct user_id) as order_number from order_tb group by date(order_time) ), b as( se...

2026-01-07

0 39