Who is the oldest captain?
select name from captain order by age desc limit 1
What about the youngest captain?
select name from captain order by age asc limit 1
How many captains are there younger than 50 in each rank?
select count ( * ), rank from captain where age < 50 group by rank