Find out how to source candidates from Stack Overflow with Super Data Ninja.

#recruitment #sourcing #recruiting #superdataninja #stackoverflow


Websites used in the video:

superdataninja.com

data.stackexchange.com
stackoverflow.com

SQL code used in the video:

DECLARE @tagName nvarchar(35) = '##tagName##'


SELECT top 50
ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Users.DisplayName as UserName,
TagName,
Location,
Reputation

FROM Tags
INNER JOIN PostTags ON PostTags.TagId = Tags.id
INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
INNER JOIN Users ON Posts.OwnerUserId = Users.Id
INNER JOIN Votes ON Votes.PostId = Posts.Id
WHERE Tags.TagName = @tagName
AND LOWER(Location) LIKE LOWER('%richmond, VA%')
AND Posts.CommunityOwnedDate IS NULL
GROUP BY TagName, DisplayName, Location, Reputation
ORDER BY Reputation DESC

свернуть