题解 | #统计出当前各个title类型的平均工资#
统计出当前各个title类型对应的员工当前薪水对应的平均工资
https://www.nowcoder.com/practice/c8652e9e5a354b879e2a244200f1eaae
重复 （昨天笔试的时候，求平均值写错了关键词AVG写成了MEAN，也是很久没写忘却了,也可以SUM(salary) / COUNT(*)，只不过还是没注意） SELECT title,AVG(salary) FROM titles JOIN salaries ON salaries.emp_no = titles.emp_no GROUP BY title SELECT title,SUM(salary) / COUNT(*) FROM titles JOIN salaries ON salaries.emp_no = titles.emp_no GROUP BY title
#MySQL#
