Database: ship_1
Question: Return the rank for which there are the fewest captains.
SQL:
SELECT rank FROM captain GROUP BY rank ORDER BY count(*) DESC LIMIT 1