统计出当前各个title类型对应的员工当前薪水对应的平均工资
统计出当前各个title类型对应的员工当前薪水对应的平均工资
http://www.nowcoder.com/questionTerminal/c8652e9e5a354b879e2a244200f1eaae
select t.title , avg(s.salary) avg
from salaries s join titles t
on s.emp_no = t.emp_no
and t.to_date='9999-01-01'
and s.to_date='9999-01-01'
group by title
;
/* 各个title类型对应的员工 group by title