Schema: CREATE TABLE FACULTY (Fname VARCHAR, Rank VARCHAR)
Question: Find the first names of faculties of rank Professor in alphabetic order.
SQL: SELECT Fname FROM FACULTY WHERE Rank = "Professor" ORDER BY Fname