Understanding SQL Joins and Window Functions

If you've ever stared at a SQL query and wondered what PARTITION BY actually does, this article is...