牛客307125317号

分类

题解(2)

/ 注册

全部文章（共2篇）

解题思路

select avg(a.salary) avg_salaryfrom salaries awhere a.to_date='9999-01-01'and a.salary not in (select max(b.salary) from salaries b where b.to_date='9...

2020-07-16

71 4025

解题

select a.emp_no as 'e.emp_no',b.dept_no,c.btype,c.receivedfrom employees a left join dept_emp b on a.emp_no=b.emp_noleft join emp_bonus c on a.emp_no=...

2020-07-16

4 494