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

时间：2022-01-02 14:46 关键词： IBM(000-730)

问题详情

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?（）

答案解析