I know early in my career I made a lot of hay rewriting database queries that were outer joins that wanted an inner join. DISTINCT in the same statement as OUTER still gives me hives.

My point is that people aren’t really getting it. Is that the fault of the pupil or the teacher? If someone wants to investigate the latter I say let them. All your surprises will be good.