nowcoder-sql-16-统计出当前各个title类型对应的员工当前薪水对应的平均工资

select t.title, avg(s.salary) avg
from titles t
inner 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