The friends table contains the following data:
Assuming a suitable collation, how can you retrieve the names in alphabetical order by last_name
then first_name?
A.
SELECT * FROM friends ORDER BY last_name, first_name DESC
B.
SELECT * FROM friends ORDER BY first_name, last_name
C.
SELECT last_name, first_name FROM friends ORDER BY last_name, first_name
D.
SELECT * FROM friends
E.
SELECT * FROM friends IN ORDER last_name, first_name
F.
You can’t order by more than one column at one time.