Show me the captain ranks
select rank from captain
Show me the captain rank that has no captain in Third-rate ship of the line class
select rank from captain where class ! = "Third-rate ship of the line"