0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 20 questions with the most down-votes (ignores up-votes)

Q&A for anime and manga fans

-- Most Down-Voted Questions Related to Java
-- The top 20 questions with the most down-votes related to Java (does NOT ignore up-votes)

WITH vote_counts AS
(
  SELECT postid,
         SUM(CASE 
               WHEN VoteTypeId = 2 THEN 1 
               WHEN VoteTypeId = 3 THEN -1 
               ELSE 0 
             END) AS vcnt
  FROM votes 
  GROUP BY postid
)

SELECT TOP 20 vcnt AS 'Net Vote Count', v.postid AS [Post Link], p.body
FROM vote_counts v
INNER JOIN posts p ON p.id = v.postid
WHERE PostTypeId = 1 
AND p.Tags LIKE '%<java>%'  -- Filter posts that have the 'java' tag
ORDER BY vcnt ASC;

fork query

edited oct 24 anonymous

created jun 3 11 jon.doe5752