As a reports author I need ranking functions ( https://docs.microsoft.com/en-us/sql/t-sql/functions/ranking-functions-transact-sql ) so that I can use them in specific scenarios.