SQL Server - LAG Funtion

SQL Server - LAG (Transact-SQL)

https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16

Additionally,

HOST_NAME

https://learn.microsoft.com/en-us/sql/t-sql/functions/host-name-transact-sql?view=sql-server-ver16

ROW_NUMBER (Transact-SQL) and Identity

https://learn.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver16

and

Zero If Null

Best Regards

Amit Vaid