Give me a list of all the last names of authors sorted in alphabetical order
SELECT lname FROM authors ORDER BY lname
last names of authors refers to lname; sorted in alphabetical order refers to ORDER BY lname ASC (though ASC is default and can be omitted);