I am looking for a kind help how to do a rank query. I need to find out the rank of a sales agent who is doing multiple leads and generating revenues. Rank would be on based on the revenue from leads table. Query will sum the revenue amounts of all of his leads and then give me the the rank of that user.