Q&A about the site for members of the workforce navigating the professional setting
-- 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 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 ('low-latency','math','matlab','mathematica','hft','quantitative-finance','fix','quickfix','finance') GROUP BY Answers.OwnerUserId, Tags.TagName ) tuser ON tuser.UserId = us.Id WHERE lower(location) like '%united states%' or (lower(location) like '%usa%' and lower(location) not like '%new england%' ) or (lower(location) like '%london%' and lower(location) not like 'london%on' and lower(location) not like '%ontario%' and lower(location) not like '%canada%' ) or (lower(location) like '%uk%' and lower(location) not like '%ukraine%' ) or lower(location) like '%sussex%' or lower(location) like '%bristol%' ORDER BY us.Id, tuser.TagName