Find the captain rank that has some captains in both Cutter and Armed schooner classes.
CREATE TABLE captain (rank VARCHAR, CLASS VARCHAR)
SELECT rank FROM captain WHERE CLASS = 'Cutter' INTERSECT SELECT rank FROM captain WHERE CLASS = 'Armed schooner'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE captain (rank VARCHAR, CLASS VARCHAR) Question: Find the captain rank that has some captains in both Cutter and Armed schooner classes. [/INST] SELECT rank FROM captain WHERE CLASS = 'Cutter' INTERSECT SELECT rank FROM captain WHERE CLASS = 'Armed schooner' </s>