DWH

0

Please login or register to vote for this query.

(click on this box to dismiss)

ExpressionEngine® Answers

Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS

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 ('data-warehouse','sql','informatica','etl')  -- for list of skils
  --Tags.Tagname like '%etl%'  -- 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results