-- Database schema
| Student : StuID [ INT ] primary_key , LName [ TEXT ] , Fname [ TEXT ] , Age [ INT ] , Sex [ TEXT ] , Major [ INT ] , Advisor [ INT ] , city_code [ TEXT ] | Faculty : FacID [ INT ] primary_key , Lname [ TEXT ] , Fname [ TEXT ] , Rank [ TEXT ] , Sex [ TEXT ] , Phone [ INT ] , Room [ TEXT ] , Building [ TEXT ] | Department : DNO [ INT ] primary_key , Division [ TEXT ] , DName [ TEXT ] , Room [ TEXT ] , Building [ TEXT ] , DPhone [ INT ] | Member_of : FacID [ INT ] Member_of.FacID = Faculty.FacID , DNO [ INT ] Member_of.DNO = Department.DNO , Appt_Type [ TEXT ] | Course : CID [ TEXT ] primary_key , CName [ TEXT ] , Credits [ INT ] , Instructor [ INT ] Course.Instructor = Faculty.FacID , Days [ TEXT ] , Hours [ TEXT ] , DNO [ INT ] Course.DNO = Department.DNO | Minor_in : StuID [ INT ] Minor_in.StuID = Student.StuID , DNO [ INT ] Minor_in.DNO = Department.DNO | Enrolled_in : StuID [ INT ] Enrolled_in.StuID = Student.StuID , CID [ TEXT ] Enrolled_in.CID = Course.CID , Grade [ TEXT ] Enrolled_in.Grade = Gradeconversion.lettergrade | Gradeconversion : lettergrade [ TEXT ] primary_key , gradepoint [ INT ] |
-- -- Find the first names of faculties of rank Professor in alphabetic order.

SELECT Fname FROM FACULTY WHERE Rank  =  "Professor" ORDER BY Fname;