Find the captain rank that has no captain in Third-rate ship of the line class.
CREATE TABLE captain (rank VARCHAR, CLASS VARCHAR)
SELECT rank FROM captain EXCEPT SELECT rank FROM captain WHERE CLASS = 'Third-rate ship of the line'
<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 no captain in Third-rate ship of the line class. [/INST] SELECT rank FROM captain EXCEPT SELECT rank FROM captain WHERE CLASS = 'Third-rate ship of the line' </s>