0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT TOP 10 u.DisplayName, COUNT(*) AS AnswerCount
FROM Posts p
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON t.Id = pt.TagId
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 2 AND t.TagName = 'streamlit'
GROUP BY u.DisplayName
ORDER BY AnswerCount DESC;

fork query

created aug 14 anonymous