Describe a scenario where you had to perform advanced SQL queries such as using window functions or CTEs to solve a complex data request.
