Walk me through a complex SQL query you wrote in a past role that involved multiple subqueries or window functions.
