Here's my quick solution in modern SQL. This is more expensive than it needs to be, but doing it this way lets you see the truth table by commenting out the final predicate.

fiddle: http://sqlfiddle.com/#!15/0c419/160/0

gist: https://gist.github.com/ibejoeb/df57cb34bbe609293d6e