Q&A for professional and enthusiast programmers
rank() over(partition by null order by [Number of Posts] desc) [Contribution Rank],
COUNT(P.Id) [Number of Posts],
from Posts P
join Users U on U.Id = P.OwnerUserId
UPPER(U.Location) like '%SOUTH AFRICA%'