How many captains with younger than 50 are in each rank?
CREATE TABLE captain (rank VARCHAR, age INTEGER)
SELECT COUNT(*), rank FROM captain WHERE age < 50 GROUP BY rank
### Context: CREATE TABLE captain (rank VARCHAR, age INTEGER) ### Question: How many captains with younger than 50 are in each rank? ### Answer: SELECT COUNT(*), rank FROM captain WHERE age < 50 GROUP BY rank