How many ships in this table?
select count ( * ) from ship
How many captains in this table?
select count ( * ) from captain
Who is the most aged captain in this table?
select captain_id from captain order by age desc limit 1
How many different ranks in this table?
select count ( distinct rank ) from captain