0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

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('%Macedonia%')
    and Tags.Tagname in ('java','spring')  -- 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

fork query

created apr 16 anonymous