instruction: How many helpful answers have I posted?. How many of my answers were either accepted or have score > 0?
response: SELECT a.Id, SUM(CASE WHEN a.PostTypeId = 2 THEN 1 END) AS Accepted, SUM(CASE WHEN a.PostTypeId = 3 THEN 1 END) AS "score>0", SUM(CASE WHEN a.PostTypeId = 4 THEN 1 END) AS "acceptedorscore>0" FROM Posts AS q INNER JOIN Posts AS a ON q.AcceptedAnswerId = a.Id WHERE a.OwnerUserId = @UserId GROUP BY a.Id, a.PostTypeId