with a as ( select count(v.Id) numVotes from Votes v inne...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature

Q&A for scholars and enthusiasts of literature

with a as (
   select count(v.Id) numVotes
   from Votes v inner join Posts p on
   v.postId = p.id
   where p.PostTypeId in (1,2)
     and v.VoteTypeId in (2,3)
)

select * from a

Enter Parameters

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