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

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