Which of the following returns a list of all customers’ names sorted in descending order by city within state?
a. SELECT name FROM customers

ORDER BY desc state, city;

b. SELECT firstname, lastname FROM customers

SORT BY desc state, city;

c. SELECT firstname, lastname FROM customers

ORDER BY state desc, city;

d. SELECT firstname, lastname FROM customers

ORDER BY state desc, city desc;

e. SELECT firstname, lastname FROM customers

ORDER BY 5 desc, 6 desc;