SQL Window Functions and CTEs

You can do quite a lot with some of the most popular SQL queries such as SELECT, WHERE, and JOIN. But...