试图显示薪资高于平均薪资的导师姓名

Question

我想做的是

SELECT tName, avg(Tutor.salary) AS avgSalary
FROM Tutor
GROUP BY tName
HAVING Tutor.salary > avgSalary;

Answer 1

由于您的问题不完整，我假设您的表tName和salary中有列Tutor。您要做的是提取平均值，然后进行比较：

SELECT tName, salary FROM Tutor
WHERE
salary > (SELECT avg(salary) FROM Tutor);