How do you use window functions like ROW_NUMBER(), RANK(), and SUM() OVER() for advanced analytical queries?
