How would you use window functions like ROW_NUMBER(), RANK(), and LEAD()/LAG() to analyze trends over time?
