• Easy enough if you know how EXCEPT and related options work.

    But don't quite understand the statement "The key to this is of course the use of DISTINCT".

    There is no use of DISTINCT, so how can it be the key to anything?