CREATE TABLE minor_in (stuid NUMBER, dno NUMBER)
CREATE TABLE course (cid CLOB, cname CLOB, credits NUMBER, instructor NUMBER, days CLOB, hours CLOB, dno NUMBER)
CREATE TABLE enrolled_in (stuid NUMBER, cid CLOB, grade CLOB)
CREATE TABLE faculty (facid NUMBER, lname CLOB, fname CLOB, rank CLOB, sex CLOB, phone NUMBER, room CLOB, building CLOB)
CREATE TABLE member_of (facid NUMBER, dno NUMBER, appt_type CLOB)
CREATE TABLE department (dno NUMBER, division CLOB, dname CLOB, room CLOB, building CLOB, dphone NUMBER)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE gradeconversion (lettergrade CLOB, gradepoint NUMBER)

What are the first names for all faculty professors, ordered by first name?
SELECT fname FROM faculty WHERE rank = "Professor" ORDER BY fname
SELECT "fname" FROM "faculty" WHERE "Professor" = "rank" ORDER BY "fname"