Examine the description of the MEMBERS table:
Examine the partial query:
SELECT city, last_name AS 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.)
To filter the cities that contain the string 'AN', the correct clause to add is 'WHERE city LIKE '%AN%'', which ensures that only cities with the 'AN' substring are selected. To order the results with cities first in ascending order and then last names (aliased as lname) in descending order, the correct clause is 'ORDER BY 1, lname DESC'. This orders the results primarily by city (the first column in the SELECT statement) in ascending order and secondarily by lname in descending order.
Option BE is right!
B-E IS CORRECT.
lname is in the question SELECT city, last_name AS lname FROM members
EF cannot be right. As the question asks us to first sort by cities in the ascending order. Only then further the sorting requires for lastname is descending order. F does vice versa
BE is correct
BE is ok , but i think EF is also right
BE is correct
lname is alias and can be used on order by
lname is in the question SELECT city, last_name AS lname FROM members
LNAME doesn't exist
LNAME is an alias for last_name and order by accepts aliases for sorting.