Whenever you're ready, walk me through how you'd approach this.
Explain how you would structure a complex query involving multiple subqueries or window functions.
