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

0

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 order by PostId


--select Title from Posts where Id = 2;


select count(Votes.PostId) from Votes 
inner join Posts as P
on Votes.PostId = P.Id
where P.PostTypeId = 2 and Votes.VoteTypeId = 2 and P.Id = 4

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results