米淇妙妙屋

分类

/ 注册

全部文章（共13篇）

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

select department, round(avg(normal_salary-dock_salary),2) as average_actual_salary, round(if(sum(if(staff_gender='male',1,0) )!=0,sum(if(staff_gende...

2025-09-25

0 31

题解 | 查询订单

select order_id,customer_name,order_date from (select order_id,customer_name, order_date,row_number() over (partition by customer_id order by order_d...

2025-09-25

0 26

题解 | 每个部门薪资排名前两名员工

select department,employee_name,salary from ( select department,employee_name,salary,row_number()over(partition by department order by salary des...

2025-09-25

0 23