Question: 1/50
Which SQL statement will retrieve all columns from the EMPLOYEES table where the SALARY is greater than 5000 and display the results sorted by LAST_NAME in ascending order?
SELECT * FROM employees WHERE salary > 5000 ORDER BY last_name;
SELECT * FROM employees WHERE salary > 5000 SORT BY last_name;
SELECT * FROM employees ORDER BY last_name WHERE salary > 5000;
SELECT * FROM employees HAVING salary > 5000 ORDER BY last_name;