Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

with questions as (
select Id
from Posts
where PostTypeId = 1 -- questions
and ClosedDate is null -- not closed)
and Score <= 0
and ViewCount >= 2000

select COUNT(CASE WHEN VoteTypeId = 2 THEN 1 END) AS [Upvotes],
  COUNT(CASE WHEN VoteTypeId = 3 THEN 1 END) AS [Downvotes]
from Votes inner join questions on Votes.PostId = questions.Id

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results