多选题Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error?（）Aremove the

remove the ORDER BY clause

remove the table alias prefix from the WHERE clause

remove the table alias from the SELECT clause

prefix the column in the USING clause with the table alias

prefix the column in the ORDER BY clause with the table alias

replace the condition d.department_id NOT IN (10,40) in the WHERE clause with d.department_id <> 10 AND d.department_id <> 40