How would you write complex joins, aggregations, subqueries, and window functions to extract business insights?