题解 | avg(s.salary)作为字段名,要加双引号
统计出当前各个title类型对应的员工当前薪水对应的平均工资
https://www.nowcoder.com/practice/c8652e9e5a354b879e2a244200f1eaae
SELECT T.title, avg(S.salary) AS "avg(s.salary)" FROM titles T JOIN salaries S ON T.emp_no = S.emp_no GROUP BY T.title ORDER BY "avg(s.salary)" ASC
需要注意的是,avg(s.salary)作为字段名使用时,要加双引号""


