Find the first names of faculties of rank Professor in alphabetic order.
CREATE TABLE FACULTY (Fname VARCHAR, Rank VARCHAR)
SELECT Fname FROM FACULTY WHERE Rank = "Professor" ORDER BY Fname
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE FACULTY (Fname VARCHAR, Rank VARCHAR) Question: Find the first names of faculties of rank Professor in alphabetic order. [/INST] SELECT Fname FROM FACULTY WHERE Rank = "Professor" ORDER BY Fname </s>