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 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

Switch sites:
loading Hold tight while we fetch your results