Potential Documentation Proposal Committers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  MAX(u.Id) as [User Link], 
  MAX(u.LastAccessDate) AS [Last on Stack], 
  MAX(u.Reputation) AS Reputation, 
  MAX(a.Score) AS [Highest Score], 
  SUM(a.Score) AS [Total Score]
FROM 
  Posts AS a
INNER JOIN
  Posts AS q
  ON q.Id = a.ParentId
INNER JOIN
  Users AS u
  ON u.Id = a.OwnerUserId
WHERE 
  q.Tags LIKE N'%visual-studio-lightswitch%' AND 
  a.PostTypeId = 2 /*Answer*/ AND
  a.Score > 0 /*With at least 1 positively scored answer (in this case zero isn't classed as positive)*/ AND
  u.Reputation >= 150 /*Must have 150 reputation*/ AND
  DATEDIFF(month, u.LastAccessDate, GETDATE()) < 18 /*Active on SO in the last 18 months*/
GROUP BY
  a.OwnerUserId
ORDER BY
  MAX(u.Reputation) DESC

Enter Parameters

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