Tendernessnick

分类

/ 注册

全部文章（共114篇）

题解 | 支付间隔平均值

with t1 as( select convert(avg(abs(timestampdiff(second,ol.logtime,sl.logtime))),unsigned) from order_log as ol left join sele...

2025-11-19

0 14

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

# 每天登陆最早的用户（时间重叠重复输出）的喜好 with t1 as( select date_format(log_time,'%Y-%m-%d') as log_day, user_id, hobby, rank()ove...

2025-11-19

0 11

题解 | 统计加班员工占比

with t1 as( select staff_id, department, timestampdiff(second,first_clockin,last_clockin)/3600, ( case...

2025-11-19

0 18

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

with t1 as( select department, avg(normal_salary-dock_salary) as avg_salary from staff_tb left join salary_tb using(st...

2025-11-19

0 13

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

with t1 as( select user_id, date_format(order_time,'%Y-%m-%d') as order_date, count(user_id) as cnt from order...

2025-11-19

0 25

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

with t1 as( select user_id, sum(if(order_price>100,order_price,0)) as add_point from order_tb where ord...

2025-11-18

0 17

题解 | 统计用户获得积分

with t1 as( select user_id, timestampdiff(minute,visit_time,leave_time) div 10 as point from visit_tb ) ,t2 as( se...

2025-11-18

0 15

题解 | 统计员工薪资扣除比例

with t1 as( select staff_id, staff_name, concat(round(dock_salary/normal_salary*100,1),'%') as dock_ratio from ...

2025-11-18

0 16

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

# 多少人访问，多少人下单 with t1 as( select distinct user_id, date_format(visit_time,'%Y-%m-%d') as visit_date from visit_tb ) ,t...

2025-11-18

0 23

题解 | 查询下订单用户访问次数？

with t1 as( select distinct user_id from visit_tb where user_id in ( select user_id ...

2025-11-18

0 14