CREATE TABLE Faculty (rank VARCHAR2, Fname VARCHAR2, Lname VARCHAR2)

Show the rank, first name, and last name for all the faculty.
SELECT rank, Fname, Lname FROM Faculty
SELECT "rank", "Fname", "Lname" FROM "Faculty"