What are the names and ranks of captains?
select name, rank from captain
Which rank is most common?
select rank from captain group by rank order by count(*) desc limit 1