This is reminiscent of the "test" they gave perdiocally when I was still in school. The instructions said "Read the entire test before starting." The questions were quite...

The EXISTS / NOT EXISTS approach is the one I would have taken. I believe EXISTS is more efficent than IN, or so I was taught for Oracle. ...