Hi,
Use the below query i hope it will give you result as per your expection.
select ITEM_ID, Sum(RATING) As TotalRATING, Rank() over (order by Sum(RATING) desc) as CurrentRank from TableName group by ITEM_ID
OutPut-
ITEM_ID |TotalRATING |CurrentRank
2 | 15 | 1
1 | 13 | 2
3 | 4 | 3
Thanks
Zubair