Users who answered questions about X

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- Users in Denmark who answered questions about Objective-C

-- Tag1: Tag 1 "Questions include ([Tag 1] or [Tag 2]) and [Tag 3]. Write them in lowercase"
-- Tag2: Tag 2 (optional) "Questions include ([Tag 1] or [Tag 2]) and [Tag 3]. Write them in lowercase"
-- Tag3: Tag 3 (optional) "Questions include ([Tag 1] or [Tag 2]) and [Tag 3]. Write them in lowercase"
-- UsersCountry: Users Country "Users location"
-- QuestionsDate: Questions Date "Questions dates are from this date forward"
-- AnswersDate: Answers Date "Answers dates are from this date forward"
-- UsersLastAccessDate: Users Last Access "Users last logged-in date are from this date forward"
SELECT
  ROW_NUMBER() OVER(ORDER BY COUNT(*) DESC, u.Reputation DESC) AS #,
  u.Id AS [User Link],
  COUNT(*) AS Answers#,
  u.Reputation,
  FORMAT(u.LastAccessDate, 'yyyy') AS [Last Access]
FROM
  (Posts AS q 
  INNER JOIN
  Posts AS a  
  ON q.Id = a.ParentId)
  INNER JOIN
  Users AS u
  ON a.OwnerUserId = u.Id
WHERE
  q.Tags LIKE '%angular%' AND
  q.Tags NOT LIKE '%angularjs%' AND
  u.Location LIKE '%[Dd]enmark%' AND
  q.CreationDate >= ##QuestionsDate:string?2000-01-01## AND
  a.CreationDate >= ##AnswersDate:string?2000-01-01## AND
  u.LastAccessDate >= ##UsersLastAccessDate:string?2000-01-01##
GROUP BY
  u.Id, u.Reputation, u.LastAccessDate

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results