首先,我搜索教授超过2门课程的姓名。
SELECT i.name, COUNT(*) teaches FROM instructor i
INNER JOIN teaches t ON i.id = t.id
GROUP BY name
HAVING COUNT(*)>=2;
目前这个技术已经生效,因此我希望能够根据这些结果提高工资。
UPDATE i SET salary = salary*1.05
FROM instructor i
INNER JOIN teaches t ON i.id = t.id
GROUP BY name HAVING COUNT(*)>=2;
出现了SQL语法错误,如何解决?