Could you help me explain why I get the following error when I enter the following SQL syntax，and how to modify it?

SQL syntax:
SELECT ID, name
FROM instructor
WHERE salary = (SELECT MAX(salary) FROM instructor)

Error: at line 3: Expected ";", "except", "fetch", "group", "having", "intersect", "limit", "offset", "order", "union", or end of input but "=" found.