how can you retrieve the names in alphabetical order by last_name then first_name?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *