Q&A for community managers, administrators, and moderators
-- Top users by tag and location -- Currently only looking at score for questions. Not sure how to fix this yet. --SELECT TOP 20 * FROM Posts SELECT top 10 us.*,tuser.Score, tuser.TagName FROM Users us JOIN (SELECT Answers.OwnerUserId AS UserId, SUM(Answers.Score) AS Score, Tags.TagName FROM Tags JOIN PostTags ON Tags.Id = PostTags.TagId JOIN Posts ON Posts.Id = PostTags.PostId JOIN Posts Answers ON Answers.ParentId = Posts.Id WHERE Tags.TagName IN ('java') GROUP BY Answers.OwnerUserId, Tags.TagName ) tuser ON tuser.UserId = us.Id WHERE (lower(location) like '%turkiye%' or lower(location) like '%turkey%' or lower(location) like 'istanbul%' or lower(location) like '%Istanbul%') ORDER BY us.Id, tuser.TagName