Examine the structure of the MEMBERS table: (Choose the best answer)
Examine the SQL statement:
SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC;
What would be the result execution?
A. It displays all cities in descending order, within which the last names are further sorted in descending order
B. It fails because a column alias cannot be used in the ORDER BY clause,
C. It fails because a column number and a column alias cannot be used together in the ORDER BY clause,
D. It displays all cities in ascending order, within which the last names are further sorted in descending order.