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
### Context: CREATE TABLE captain (CLASS VARCHAR, age INTEGER) ### Question: What are the average and minimum age of captains in different class? ### Answer: SELECT AVG(age), MIN(age), CLASS FROM captain GROUP BY CLASS