首先,我搜索教授两门以上课程的人的名字
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语法中的错误;如何修复它?