Query Review: Employee Lookup

Interviewer prompt: The query below fails during a live interview. Your task: 1) Identify the root cause 2) Provide corrected SQL SELECT id name, department FROM employees WHERE department = 'Sales';

employees(id, name, department, salary)