How would you write complex joins, window functions, and aggregations to pull specific cohorts of student or financial data?