For each class, what are the ranks?
select distinct class, rank from captain order by class
Find the captain rank that has no captain in Third-rate ship of the line class.
select rank from captain except select rank from captain where class = 'Third-rate ship of the line'