0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

-- create table with number of votes per question (posttypeid = 1)
with a as (
   Select top 1000 Count(v.PostId) n_votes
   from Votes v join Posts p 
   on v.PostId = p.Id
   where p.PostTypeId in (1) and v.VoteTypeId in (2,3)
)

select * from a

view current version

edited nov 21 19

created nov 21 19 anonymous