Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
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%'