题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#
统计出当前各个title类型对应的员工当前薪水对应的平均工资
http://www.nowcoder.com/practice/c8652e9e5a354b879e2a244200f1eaae
step1:取出需要的字段； step2：关联、聚合运算
select title
,avg(salary)
from (
select title
,emp_no
from titles
)p1
inner join
(
select salary
,emp_no
from salaries
)p2
on p1.emp_no = p2.emp_no
group by title
order by avg(salary) asc
查看14道真题和解析