Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
;with cte as (
from Posts P
join Users U on U.id = P.OwnerUserId
upper(U.Location) like '%SOUTH AFRICA%'
rank() over (
partition by null