Table schema:
CREATE TABLE captain (name VARCHAR, CLASS VARCHAR, rank VARCHAR)

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