Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing
; with qacounts_cte AS (SELECT OwnerUserId AS uid, OwnerDisplayName AS udn, COUNT(Id) AS Pcount, SUM(case when PostTypeId = 1 then 1 else 0 end) AS QCount, SUM(case when PostTypeId = 2 then 1 else 0 end) AS ACount FROM Posts GROUP BY OwnerUserId, OwnerDisplayName ) SELECT TOP(##num?500##) uid AS [User Link], udn AS [Display Name], ROUND(QCount*100.0/PCount,2) AS percQ, ROUND(ACount*100.0/PCount,2) AS percA, ACount, QCount, PCount FROM qacounts_cte ORDER BY PCount DESC