tommyh (9/19/2011)

---

JOIN (SELECT StudentId as StudentNumber, max(RequestNbr) as RequestNb
        FROM Request
        ...
        GROUP BY StudentId) as Latest (StudentId, RequestNbr)
     ON Request.StudentId = Latest.StudentId
     AND Request.RequestNbr = Latest.RequestNbr

Just to clearify. The whole point was to point out that the bold parts dont match and that SQL instead is using the italic names in the join?

If above is true then read on... otherwise ignore:
I got the answer right for all the wrong reasons. I simply didnt see the change in the names. And it took one heck off a time to see the change in the names. When i first read the question i was so sure it would be something odd about the DATE datatype (since one answer had timeportion in it) or something with the MAX in the subquery. So i focused on that but couldnt find anything odd about it. So that left me with only one answer. Which was the right answer.

PS Im not being sarcastic or anything. I for one learned something... if my assumption is correct. Its just that in this case i feel like the point was drowned in code that wasnt relevant. Though atleast it made me think ALOT

/T

stewartc-708166 (9/19/2011)

---

Thanks for the question, Jason
I actually quite enjoyed analysing this from all angles.

Toreador (9/19/2011)

---

Got it right, even though the correct answer isn't listed. But I guessed rightly that the author assumed we all use US date formats

Thomas Abraham (9/19/2011)

---

Thanks. Got it right - but almost went for the first instance of the name change. Good thing I kept "parsing". Thanks for the lesson!