【sql】SQL16 统计出当前各个title类型对应的员工当前薪水对应的平均工资

题目：

统计出当前各个title类型对应的员工当前薪水对应的平均工资_牛客题霸_牛客网

有一个员工职称表titles简况如下:

emp_no	title	from_date	to_date
10001	Senior Engineer	1986-06-26	9999-01-01
10003	Senior Engineer	2001-12-01	9999-01-01
10004	Senior Engineer	1995-12-01	9999-01-01
10006	Senior Engineer	2001-08-02	9999-01-01
10007	Senior Staff	1996-02-11	9999-01-01

有一个薪水表salaries简况如下:

emp_no	salary	from_date	to_date
10001	88958	1986-06-26	9999-01-01
10003	43311	2001-12-01	9999-01-01
10004	74057	1995-12-01	9999-01-01
10006	43311	2001-08-02	9999-01-01
10007	88070	2002-02-07	9999-01-01

请你统计出各个title类型对应的员工薪水对应的平均工资avg。结果给出title以及平均工资avg，并且以avg升序排序，以上例子输出如下:

title	avg(s.salary)
Senior Engineer	62409.2500
Senior Staff	88070.0000

题解：

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