What are the first names of the people in alphabetical order?
SELECT first_name FROM people ORDER BY first_name
first names of the people in alphabetical order refers to ORDER BY first_name ASC (ascending order is default when ORDER BY is used);