Which classes have more than two captains?
CREATE TABLE captain (CLASS VARCHAR)
SELECT CLASS FROM captain GROUP BY CLASS HAVING COUNT(*) > 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE captain (CLASS VARCHAR) Question: Which classes have more than two captains? [/INST] SELECT CLASS FROM captain GROUP BY CLASS HAVING COUNT(*) > 2 </s>