Yes, it was relatively simple to analyze, but some of the QOD's should be at an elementary level. Not all members of this community are seasoned DBAs or developers.

As a note, I often try, as I did this time, to predict an answer from the copy of the question in the email newsletter, before seeing the multiple choices. That approach does crank up a few extra brain cells.

Henrico, thanks for submitting this one. I'm taking a reminder here that sometimes it's best to break down a problem first and see if a simple component (ID < 2) will give the answer without having to delve into the complicated other parts. It's like those math riddles which have all sorts of strange stuff and end up with the anwer being zero: ((ln 23 / (19^16))*((2^3)-(64^0.5))