What are the average and minimum age of captains in different class?
CREATE TABLE captain (CLASS VARCHAR, age INTEGER)
SELECT AVG(age), MIN(age), CLASS FROM captain GROUP BY CLASS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE captain (CLASS VARCHAR, age INTEGER) Question: What are the average and minimum age of captains in different class? [/INST] SELECT AVG(age), MIN(age), CLASS FROM captain GROUP BY CLASS </s>