牛客768350767号

分类

/ 注册

全部文章（共32篇）

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

with a as( select d.emp_no as emp_no,d.dept_no as dept_no, s.salary as salary from dept_emp d join salaries s using(emp_no)), b as( ...

2025-10-20

0 5

题解 | 查找在职员工自入职以来的薪水涨幅情况

with a as( select emp_no,salary as now_salary from salaries where to_date='9999-01-01'), b as( select e.emp_no as emp_no,s.salary ...

2025-10-17

0 11

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

with s as( select emp_no,salary from salaries where salary=( select max(salary) from salaries where salary<(select max(salary) from salaries))) sel...

2025-10-17

0 9

题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息

select*from employees where emp_no in (select emp_no from( select emp_no,dense_rank()over(order by hire_date desc) as rk from employees) sub where sub...

2025-10-15

0 7

题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况

with s1 as( select e.employee_id as employee_id, e.performance_score as performance_score, d.department_id as department_id, d.departm...

2025-08-26

0 23

题解 | 贷款情况

with sub1 as( select b.city as city, round(sum(a.loan_amount),2) as total_loan_amount, round(sum(a.loan_amount)/count(distinct b.customer_...

2025-08-25

0 27

题解 | 查询高价值旅行套餐客户的支出与套餐详情

select c.name as customer_name, sum(p.price) as total_travel_cost, count(*) as order_count, round(avg(p.price),2) as avg_order_price from bookings b j...

2025-08-19

0 19

题解 | 分析各产品线在特定时间段内的销售情况

select a.product_line,b.region,b.channel_name, sum(c.sale_amount) as total_sale_amount, count(*) as total_sale_quantity from oppo_products a join sale...

2025-08-19

1 26

题解 | 深入分析各款产品年总销售额与竞品的年度对比

with b as( select product_id,sum(quarter_1_sales_amount+quarter_2_sales_amount+quarter_3_sales_amount+quarter_4_sales_amount) as total_sales_amoun...

2025-08-19

0 23

题解 | 饿了么需要分析不同配送员在不同天气条件下的配送效率和用户投诉情况

select w.weather_type as weather_type, round(avg(d.delivery_time),2) as average_delivery_time, count(*) as delivery_count from delivery_records d join...

2025-08-19

0 24