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