0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

SELECT TOP 50 
  u.Id, SUM(CASE WHEN q.AcceptedAnswerId=a.Id THEN 1 ELSE 0 END) as AnsAcc
  FROM USERS u INNER JOIN POSTS q ON u.Id = q.OwnerUserId
       LEFT OUTER JOIN POSTS a ON q.AcceptedAnswerId = a.id 
       WHERE (q.OwnerUserId <> a.OwnerUserId) and u.Reputation > 40000
  
  GROUP BY u.Id

view current version

edited sep 9 14

created sep 5 14 anonymous