0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for electronics and electrical engineering professionals, students, and enthusiasts

SELECT TOP(##num?100##)
  q.OwnerUserId as [User Link], q.OwnerDisplayName, 
  COUNT(q.Id) AS [Count], SUM(q.Score) AS [Score]
FROM Posts q INNER JOIN Posts a ON q.Id=a.ParentId
WHERE (a.OwnerUserid=##userid##)
GROUP by q.OwnerUserId, q.OwnerDisplayName
ORDER BY COUNT (a.Id) DESC

fork query

edited jan 27 anonymous

created jan 26 Martin20528