Q&A for scientists using computers to solve scientific problems
with AnswerScores AS ( SELECT Users.Id AS [User Link], SUM(Answers.Score) AS Score FROM Posts AS Answers INNER JOIN Posts AS ParentQuestions ON ParentQuestions.Id = Answers.ParentId INNER JOIN Users AS Users ON Answers.OwnerUserId = Users.Id INNER JOIN PostTags ON PostTags.PostId = Answers.ParentId INNER JOIN Tags ON Tags.Id = PostTags.TagId WHERE LOWER(Location) LIKE LOWER('%Serbia%') and Tags.Tagname in ('java','hibernate') -- for list of skils --and Tags.Tagname like '%sql%' -- for skills having this in part of the tag name GROUP BY Users.Id ) SELECT Users.DisplayName, AnswerScores.[User Link], Users.Reputation FROM AnswerScores INNER JOIN Users ON AnswerScores.[User Link] = Users.Id Where 1=1