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], QCount FROM qacounts_cte WHERE ACount=0 ORDER BY QCount DESC