数据库SQL实战-16.统计出当前各个title类型对应的员工当前薪水对应的平均工资

select t.title,avg(salary) as avg
from salaries as s join titles as t
on s.emp_no = t.emp_no
and s.to_date = '9999-01-01'
and t.to_date = '9999-01-01'
group by title

考察join连接和分组统计