What are the first names of all the faculty?
select fname from faculty
Of those, which are professors?
select fname from faculty where rank = "Professor"
Sort this in alphabetical order.
select fname from faculty where rank = "Professor" order by fname