Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language
DECLARE @tagName nvarchar(35) = '##tagName##' SELECT top 20 TagName, Location, SUM(case votes.votetypeid WHEN 2 THEN 1 -- upvote WHEN 3 THEN -1 -- downvote END) as Rep, Users.DisplayName as UserName, number = ROW_NUMBER() OVER (ORDER BY TagName) 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('London') AND Posts.CommunityOwnedDate IS NULL GROUP BY TagName, DisplayName, Location ORDER BY Rep DESC