OCP CBT Question 647

Please solve the following question.

Examine the following SQL statement:

sqlSELECT employee_id, first_name, salaryFROM employeesWHERE salary > 10000ORDER BY salary DESC;

EMPLOYEES Table Structure

It retrieves employee IDs, first names, and salaries for employees earning exactly 10000, sorted in ascending order of salary.

It retrieves employee IDs, first names, and salaries for employees earning more than 10000, sorted in descending order of salary.

It retrieves all employee IDs, first names, and salaries, sorted in descending order of salary.

It causes an error because the ORDER BY clause must precede the WHERE clause.