壹壹风荷举

分类

/ 注册

全部文章（共80篇）

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

with man_sal as ( select dm.emp_no, dept_no , salary as manager_salary from dept_manager dm join salaries s on s.emp_no=dm.emp_no ), emp_sal as ( sele...

2025-12-19

0 19

题解 | 获取所有非manager员工当前的薪水情况

select de.dept_no ,de.emp_no ,salary from dept_emp de left join dept_manager dm on dm.emp_no=de.emp_no join salaries s on s.emp_no=de.emp_no where dm...

2025-12-19

0 14

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

with s2 as ( select emp_no ,salary as salary2 from ( select emp_no,salary from salaries where to_date='9999-01-01' ) t ), s1 as ( select e.emp_no, sal...

2025-12-18

0 26

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

select e.emp_no,salary,last_name,first_name from employees e join salaries s on s.emp_no =e.emp_no where salary=( select max(salary) from salarie...

2025-12-18

0 20

题解 | 10月的新户客单价和获客成本

with rank_order as ( select uid,total_amount,total_cnt,status,order_id, event_time , row_number() over(partition by uid order by event_time) as r...

2025-12-06

0 26

题解 | 连续签到领金币

WITH valid_log AS ( select distinct uid, date(in_time) as dt from tb_user_log where artical_id=0 and sign_in =1 ...

2025-12-06

0 18

题解 | 国庆期间每类视频点赞量和转发量

with sum_temp as ( select tag,date_format(start_time,'%Y-%m-%d') as dt , sum( if_retweet) as retweet_cnt, sum(if_like ) as like_cnt from tb_video_inf...

2025-12-03

0 18

题解 | 目标月份的品类销售简报

select category,orders_cnt,buyers_cnt,items_qty,revenue, round(revenue/orders_cnt,2) avg_order_value, rank() over(order by revenue desc,orders_cnt des...

2025-11-18

0 34

题解 | 医院门诊复诊率与抗生素用药占比统计

with feb_count_temp as ( select dept,count(distinct v.visit_id) as feb_2024_visits, count(distinct patient_id ) as feb_2024_unique_patients, coalesce(...

2025-11-16

1 25

题解 | 下单复盘

select c.customer_id,customer_name, count(t.order_id) as feb_2024_order_count,coalesce(sum(amount),0.00) as feb_2024_total_amount, coalesce(round(sum(...

2025-11-14

1 25