Show the rank, first name, and last name for all the faculty.
CREATE TABLE Faculty (rank VARCHAR, Fname VARCHAR, Lname VARCHAR)
SELECT rank, Fname, Lname FROM Faculty
### Context: CREATE TABLE Faculty (rank VARCHAR, Fname VARCHAR, Lname VARCHAR) ### Question: Show the rank, first name, and last name for all the faculty. ### Answer: SELECT rank, Fname, Lname FROM Faculty