刘青丰

分类

/ 注册

全部文章（共14篇）

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

with t1 as ( select department,(normal_salary - dock_salary) as salary from staff_tb join salary_tb using(staff_id) ) select department,round(...

2025-03-13

1 79

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

select sa.staff_id, staff_name, concat(round((dock_salary/normal_salary)*100,1),'%') as dock_ratio from staff_tb as st join salary_tb as...

2025-03-13

1 51

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

select v.user_id, count(distinct visit_time) as visit_nums from order_tb as o join visit_tb as v on o.user_id = v.user_id and date(visit_time) = '202...

2025-03-13

5 92

题解 | 最长连续登录天数

with t1 as ( select user_id, fdate, date_sub(fdate,interval (row_number() over (partition by user_id order by fdate)-1) d...

2025-03-13

1 63