What are the names, classes, and ranks of all captains?
select name, class, rank from captain