XiaoBY

分类

/ 注册

全部文章（共48篇）

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

select job, concat (year (date), '-', LPAD(MONTH(date), 2, '0')) as mon, sum(num) as cnt from resume_info where year(date) = 2025 grou...

2024-12-16

0 78

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

select oi.id, is_group_buy, if(is_group_buy = 'NO',name, 'None') as client_name from order_info oi left join client c on oi.client...

2024-12-16

0 72

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

select user_id from order_info where date > '2025-10-15' and status = 'completed' and (product_name in ('Java', 'C++', 'Python'...

2024-12-16

0 89

题解 | 平均工资

select avg(salary) from salaries where to_date = '9999-01-01' and ( salary <> ( select max(s...

2024-12-15

0 78

题解 | #查找所有员工的last_name和first_name以及对应的dept_name#

select last_name, first_name, dept_name from dept_emp left join departments on dept_emp.dept_no = departments.dept_no right jo...

2024-12-11

0 79

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

select title, avg(salary) as sal from titles inner join salaries on titles.emp_no = salaries.emp_no group by title order by sal asc

2024-12-11

0 71

题解 | #获取所有非manager的员工emp_no#

select employees.emp_no from employees left join dept_manager on employees.emp_no = dept_manager.emp_no where dept_manager.dept_no is null

2024-12-09

0 56

题解 | #浙大不同难度题目的正确率#

select qd.difficult_level, sum(if(result = 'right',1,0))/count(result) as correct_rate from question_practice_detail as upd left join us...

2024-12-05

0 59