South African developers that user SO

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

;with cte as (
  select
  U.Id UserId,
  U.Reputation,
  U.WebsiteUrl,
  'https://stackoverflow.com/users/' + cast(U.id as varchar) StackOverflowProfile,
  U.AboutMe,
  U.Location,
  U.DisplayName,
  count(P.id) [InteractionCount]
  
  from Posts P
  join Users U on U.id = P.OwnerUserId
  
  where
  upper(U.Location) like '%CAPE TOWN%'
  
  group by
  U.Id,
  U.Reputation,
  U.WebsiteUrl,
  U.Location,
  U.AboutMe,
  U.DisplayName
)

select
*,
rank() over (partition by null order by cte.InteractionCount desc) InteractionCountRank

from cte

order by
Reputation desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results