牛客251960512号

题解

markdown(1) MySQL(15) numpy(3) Obsidian(6) pandas(6) PPT(1) Pyhon面向对象(1) Python基础语法(60) Python数据分析与展示(11) python自动化(2) Tableau(17) 可视化(3) 未归档(1) 百度(1) 系统(1) 系统问题(1)

/ 注册

全部文章 / 题解（共33篇）

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

方法1 select de.dept_no, e.emp_no, s.salary from employees e join dept_emp de on e.emp_no = de.emp_no join salaries s on e.emp_no = s.emp_no left join ...

Mysql

2021-10-28

0 346

题解 | #获取有奖金的员工相关信息。#

select e.emp_no,e.first_name, e.last_name, eb.btype,s.salary , case when eb.btype =1 then s.salary*0.1 when eb.btype =2 then s.salary*0.2 e...

Mysql

2021-10-28

0 374

题解 | #统计各个部门的工资记录数#

select d.dept_no, d.dept_name, count(s.salary) sum from salaries s left join dept_emp de on s.emp_no = de.emp_no left join departments d on d.dept_...

Mysql

2021-10-27

0 297

题解 | #牛客的课程订单分析(四)#

select user_id,min(date) first_buy_date,count(user_id) cnt from order_info where date > '2025-10-15' and product_name in ('C++','Java','Python') an...

Mysql

2021-10-26

0 300

题解 | #考试分数(二)#

select id , job ,score from grade g where score > ( select round(avg(score),3) from grade sub where g.job = sub.job ) order by id

Mysql

2021-10-26

0 301

题解 | #刷题通过的题目排名#

select id ,number ,dense_rank() over(order by number desc) t_rank from passing_number

Mysql

2021-10-25

0 282

题解 | #实习广场投递简历分析(二)#

select job ,date_format(date,'%Y-%m') mon ,sum(num) cnt from resume_info where year(date) = 2025 group by mon,job order by mon desc, cnt desc

Mysql

2021-10-25

0 341

题解 | #获取所有员工当前的manager#

select de.emp_no,dm.emp_no from dept_emp de join dept_manager dm on de.dept_no = dm.dept_no where de.emp_no != dm.emp_no

Mysql

2021-10-25

1 274

题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#

select t.title, avg(s.salary) from salaries s join titles t on s.emp_no = t.emp_no group by t.title

Mysql

2021-10-25

0 207

题解 | #统计salary的累计和running_total#

select emp_no, salary , sum(salary) over(order by emp_no) as running_total from salaries where to_date = '9999-01-01'

mysql

2021-10-22

0 259