CREATE TABLE FACULTY (Fname VARCHAR, Rank VARCHAR)

Find the first names of faculties of rank Professor in alphabetic order.
SELECT Fname FROM FACULTY WHERE Rank = "Professor" ORDER BY Fname
SELECT "Fname" FROM "FACULTY" WHERE "Professor" = "Rank" ORDER BY "Fname" NULLS FIRST