1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professors, theologians, and those interested in exegetical analysis of biblical texts

; with closed_cte as
(
SELECT
u.Id AS uid,
Count(q.Id) AS QuestionCount,
Count(q.ClosedDate) AS ClosedCount
FROM Posts q INNER JOIN Users u ON q.OwnerUserId=u.Id
WHERE (q.PostTypeId = 1)
  AND (q.CreationDate >= '##Date1?2000-01-01##') AND (q.CreationDate <= '##Date2?3000-01-01##')
GROUP BY u.Id
)

SELECT
  uid AS [User Link],
  ROUND((CAST(ClosedCount AS decimal))*100.0/(CAST(QuestionCount AS decimal)),2) AS percentage,
  ClosedCount, QuestionCount
FROM closed_cte
WHERE QuestionCount>=##min?10##
ORDER BY ROUND((CAST(ClosedCount AS decimal))*100.0/(CAST(QuestionCount AS decimal)),2) DESC

fork query

created nov 1 22 Martin20528