I currently have this query and I want to add Ranking but I can't figure it out.
Select UnderwriterContact, Sum(LoanCount) AS LoanCount
WHERE Cast(StatusDate as Date) = Cast(GETDATE() as Date)
GROUP by UnderwriterContact
ORDER by LoanCount DESC
I want the results to look like the attached - with Rankings
Any help is greatly appreciated!