respostas postadas, quantos por cento não possuem nenhum upvote?


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

/*select COUNT(Posts.Id) from Posts
INNER JOIN Posts  as P
on P.AcceptedAnswerId = Posts.Id
where Posts.PostTypeId = 2*/

/*select count(Id) from Posts
where PostTypeId = 2*/

--Dentre todas as respostas postadas no StackOverflow em português 
--quantos por cento não possuem nenhum upvote?

select * from Votes where VoteTypeId = 2

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results