Examine the description of the MEMBERS table:
Examine the partial query:
SELECT city, last_name LNAME FROM members …;
You want to display all cities that contain the string AN. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query? (Choose two.)
A. ORDER BY last_name DESC, city ASC
B. WHERE city IN (‘%AN%’)
C. ORDER BY 1, LNAME DESC
D. ORDER BY 1, 2
E. WHERE city = ‘%AN%’
F. WHERE city LIKE ‘%AN%’
Lol who put the answer here it’s a BIG difference from the actual asnwer wow.
CF correct.
C and F are correct, A will give wrong result
this is shitty CF IS ANSWER
CF
There is big difference between A and C.
A sorts by Last Name in desc and then City in asc
B sorts by city and then last name
C and F are correct
What is the difference between A and C?
Answer CF or AF