Find the name, class and rank of all captains.
CREATE TABLE captain (name VARCHAR, CLASS VARCHAR, rank VARCHAR)
SELECT name, CLASS, rank FROM captain
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE captain (name VARCHAR, CLASS VARCHAR, rank VARCHAR) Question: Find the name, class and rank of all captains. [/INST] SELECT name, CLASS, rank FROM captain </s>