老师，这里的报错是啥问题

DELETE e,s
FROM employee e
JOIN salary s ON s.employee_id = e.id
WHERE e.department_id = 2
ORDER BY (s.basic_salary + s.bonus + s.performance) DESC
LIMIT 1;

执行 sql 时候报错了，但是根据课程中老师说的，语法因该没错才对；

DELETE e,s
FROM employee e
JOIN salary s ON s.employee_id = e.id
WHERE e.department_id = 2
ORDER BY (s.basic_salary + s.bonus + s.performance) DESC
LIMIT 1
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY (s.basic_salary + s.bonus + s.performance) DESC
LIMIT 1' at line 5
> Time: 0s
>