Find the name, class and rank of all captains.
CREATE TABLE captain (name VARCHAR, CLASS VARCHAR, rank VARCHAR)
SELECT name, CLASS, rank FROM captain
### Context: CREATE TABLE captain (name VARCHAR, CLASS VARCHAR, rank VARCHAR) ### Question: Find the name, class and rank of all captains. ### Answer: SELECT name, CLASS, rank FROM captain