What are the names of the captains that have classes?
select name from captain where class ! =  'NULL'
names of the captains that have classes refers to selecting name from captain where class is not NULL;