0

Please login or register to vote for this query.

(click on this box to dismiss)

Вопросы и ответы для программистов

select 
   sum(case when a.Score=0 and a.CommentCount is null then 1 else 0 end) as [Unappreciated Answers], 
   count(a.Id) as [Total Answers], 
   100*cast(sum(case when a.Score=0 and a.CommentCount is null then 1 else 0 end) as float)/count(a.Id)  as [Percentage Unappreciated]
FROM Posts a
WHERE a.PostTypeId=2

fork query

edited jan 4 14 anonymous

created jan 4 14 jon.doe12549