A distribution of all your unscored answers.
Q&A for community managers, administrators, and moderators
SELECT /* a.Id as [Post Link], a.Score, a.CommunityOwnedDate, a.postTypeId, a.AcceptedAnswerId, q.AcceptedAnswerId as [AnswerID],*/ Count(*) as AnswerCount, IsAccepted /*(case st when q.AcceptedAnswerId <> NULL then "Accepted" when q.AcceptedAnswerId IS NULL then "UnAccpted" end st)*/ --on a.Id = q.AcceptedAnswerId --v.VoteTypeId FROM ( select case when q.Id is null then 0 else 1 end as IsAccepted from Posts a left join Posts q ON a.Id = q.AcceptedAnswerId WHERE a.OwnerUserId = ##UserId## and a.postTypeId = 2 and a.score = 0 ) x GROUP BY IsAccepted --(case when q.AcceptedAnswerId > 0 then [Accepted] else [UnAccpted] end)