I hope more books gets plagiarized so we can get to win more books!

Kidding.

Here's my take on a query with an OVER statement:

DROP TABLE #HEY

CREATE TABLE #HEY (Region CHAR(10),Age INT,...