This time we talk about #Windowing functions in #SQL Server. They are useful when we want to access grouped or aggregated data on the current row context in order to do calculations or other logics. Blog that explains rows unbounded precding statements: https://blog.sqlauthority.com/2011/11... World Wide Importers Database: https://github.com/Microsoft/sql-serv... Definition of YTD: https://en.wikipedia.org/wiki/Year-to... Discord: / discord