Thanks Michael for doing this article. I thought it was a good explanation and example.

However I was also distracted by the window/windows difference and some typos / misspellings.

Here are a couple more I found:

"They wanted to know when the most resent order’s code was different from the one previous to it." (I think you meant "recent," not that it was re-sent. It seems to be correct everywhere else)

"In this case we want to partition our recordset by ORDER_ID, essentially grouping all rows with the sam ORDER_ID together."

(sam/same)