SELECT count(*) ,  rank FROM captain WHERE age  <  50 GROUP BY rank
How many captains with younger than 50 are in each rank?
SELECT count ( * ) , rank FROM captain WHERE age < 50 GROUP BY rank
select count ( * ) , rank from captain where age < value group by rank
How many captains with younger than 50 are in each rank ?