Which rank is the most common among captains?
SELECT rank FROM captain GROUP BY rank ORDER BY count(*) DESC LIMIT 1
SELECT rank FROM captain GROUP BY rank ORDER BY count(*) DESC LIMIT 1
[{'Rank': 'Midshipman'}]