不想上网课的高级磨洋工练习时长两年半

分类

/ 注册

全部文章（共69篇）

题解 | 查找薪水记录超过15条的员工号emp_no以及其对应的记录次数t

select emp_no,t from (select emp_no, count(emp_no) as t from salaries group by emp_no ) as A where A.t >= 15;

2025-10-02

0 21

题解 | 查找所有员工的last_name和first_name以及对应部门编号dept_no

select A.last_name,A.first_name,B.dept_no from employees A LEFT join dept_emp B on A.emp_no = B.emp_no

2025-10-02

0 14

题解 | 查找所有已经分配部门的员工的last_name和first_name以及dept_no

select A.last_name,A.first_name,B.dept_no from employees A INNER join dept_emp B on A.emp_no = B.emp_no

2025-10-02

0 14

题解 | 查找当前薪水详情以及部门编号dept_no

select A.emp_no,A.salary,A.from_date,A.to_date, B.dept_no from salaries A INNER join dept_manager B on A.emp_no = B.emp_no order by A.emp_no ASC

2025-10-02

0 18

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

SELECT emp_no, birth_date, first_name, last_name, gender, hire_date FROM ( SELECT dense_rank() OVER ( ...

2025-10-02

0 16

题解 | 查找最晚入职员工的所有信息

select * from employees where hire_date = (select MAX(hire_date) from employees)

2025-10-02

0 19

题解 | 基本数学函数

select id,value,ABS(value) as absolute_value,CEIL(value) as ceiling_value, floor(value) as floor_value,round(value,1) as rounded_value from numbers ...

2025-09-29

0 13

题解 | 计算每日累计利润

select profit_id,profit_date,profit, sum(profit) over (order by profit_id) as cumulative_profit from daily_profits

2025-09-29

0 21

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

select Ques.difficult_level as difficult_level ,sum(IF(Ques.result = 'right',1,0))/count(Ques.result) as correct_rate from user_profile A left join (s...

2025-09-29

0 18

题解 | 统计复旦用户8月练题情况

SELECT u.device_id, university, sum(case when result IS NULL then 0 else 1 end) as question_cnt, sum(case when result = 'right' then 1 else 0 end) as ...

2025-09-29

0 18