Post Basics, Filtered (Tutorial)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow em Português

Perguntas e respostas para programadores profissionais e entusiastas

select top 500 concat('https://stackoverflow.com/questions/', PostId), Upvotes, Downvotes
from (
    select PostId, Upvotes, Downvotes, Upvotes - Downvotes as s
    from (
        select
            PostId, 
            Upvotes = sum(case when VoteTypeId = 2 then 1 else 0 end),
            Downvotes = sum(case when VoteTypeId = 3 then 1 else 0 end)
        from Votes
        where VoteTypeId in (2,3)
        group by PostId
    ) as VoteCounts inner join Posts on Posts.Id = VoteCounts.PostId
    where Upvotes >= 0 and Downvotes >= 0
) as Scores
where s >= 100
order by s desc

Enter Parameters

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