0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT   COUNT(1) AS [Total],
         COUNT(CASE WHEN [Score] >= 10 THEN 1 ELSE NULL END) AS [EGT10],
         COUNT(CASE WHEN [Score]  < 10 THEN 1 ELSE NULL END) AS [LG10]
FROM     [Posts]
WHERE    [PostTypeId] = 2
AND      [DeletionDate] IS NULL
AND      [OwnerUserId] = ##UserId##
;

fork query

edited sep 22 16

created sep 22 16 tj