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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Faculty (rank VARCHAR, Fname VARCHAR, Lname VARCHAR) Question: Show the rank, first name, and last name for all the faculty. [/INST] SELECT rank, Fname, Lname FROM Faculty </s>