单选题Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）A SORT BY age ASC, last_name
题目
单选题
Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）
A
SORT BY age ASC, last_name
B
SORT BY age DESC, last_name
C
ORDER BY age DESC, last_name
D
ORDER BY age ASC, last_name