Database: college_3
Question: What are the first names for all faculty professors, ordered by first name?
SQL:
SELECT Fname FROM FACULTY WHERE Rank  =  "Professor" ORDER BY Fname