Easy question. You get it right by analyzing the innermost queries first and then understanding how the NOT IN operator works in the outermost query.
I love this kind of questions. Thank you. 🙂
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA