SELECT rank FROM captain GROUP BY rank ORDER BY count(*) DESC LIMIT 1
Return the rank for which there are the fewest 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
Return the rank for which there are the fewest captains .