啊坡糍嘚

题解

/ 注册

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

题解 | #查找排除当前最大、最小salary之后的员工的平均工资avg_salary#

select avg(salary) as avg_salaryfrom salarieswhere salary !=(select max(salary) from salaries where to_date='9999-01-01')and salary !=(select min(sala...

sql 刷题数据分析

2021-09-13

0 564