呼吸丶zero

分类

/ 注册

全部文章（共33篇）

题解 | 商品销售总额分布

select case when u.pay_method = '' then 'error' else u.pay_method end as pay_method, count(*) as num from user_client_...

2025-07-13

0 36

题解 | 商品价格排名

with t as ( select product_id, product_name, type, price, rank() over ( ...

2025-07-13

0 34

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

select department, average_actual_salary, if(average_actual_salary_male is null,0.00,average_actual_salary_male) as average_actual_salary_...

2025-07-13

0 45

题解 | 统计快递运输时长

select exp_type ,round(avg(timestampdiff(minute,out_time,in_time)/60),1) as time from express_tb join exp_action_tb using(exp_number) group by exp_typ...

2025-07-12

0 33

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

select date(order_time) as order_date ,user_id ,count(*) as order_nums ,vip from order_tb join uservip_tb using(user_id) group by order_date,user_id h...

2025-07-10

0 43

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

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

2025-07-09

0 38

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

with t as ( select distinct user_id from order_tb where date(order_time) = '2022-9-2' ...

2025-07-09

0 37

题解 | 统计各等级会员用户下订单总额

select vip , sum(case when order_price is null then 0 else order_price end) as order_total from order_tb right join uservip_tb using(user_id) group by...

2025-07-09

0 34

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

select user_id from ( select user_id, if(lead(log_date) over (PARTITION BY user_id ORDER BY log_date) - lo...

2025-07-08

1 45

题解 | 查询培训指定课程的员工信息

select staff_id ,staff_name from staff_tb join cultivate_tb using(staff_id) where course like '%course3%'

2025-07-07

0 52