You'll often find that the data you need is spread across multiple tables or
requires complex calculations that simple GROUP BY queries can't handle. Two
of the most powerful tools in your SQL toolbox for solving these challenges are
JOINS and Window Functions.
While Joins allow us to stitch together data from multiple tables, Window
Functions...