Ok, I figured it out, but the syntax is not intuitive. I had to start at the end of the statement and work backwards.

In listing 6 you use some logic for Id in the select part of the statement, but I can't figure out what that part is doing. Specifically the "7+(6-Id)", what...