Which Ships Do Not Have a Crew Yet?

What if I wanted to do the same sort of analysis but in the other direction, what if I wanted to know which ships do not have crews yet?

You may recall that my Ships table had quite a few records (over 100)

So I am expecting lots of NULL values in the result

In this example we are going to do a

LEFT OUTER JOIN