SELECT rank FROM captain GROUP BY rank ORDER BY count(*) DESC LIMIT 1
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 value
Which rank is the most common among captains ?