Database: ship_1
Question: Find the name, class and rank of all captains.
SQL:
SELECT name ,  CLASS ,  rank FROM captain