Func 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Biology

Q&A for biology researchers, academics, and students

with a as (select Id, Cast(CreationDate as Date) as day from Votes where VoteTypeId=3),
b as (select Count(Id) as down, day from a group by day),
c as (select Id, Cast(CreationDate as Date) as day from Votes where VoteTypeId=2),
d as (select Count(Id) as up, day from c group by day)
select d.day, b.down-d.up as 'Downvote-Upvote ratio' from b right join d on b.day=d.day order by d.day;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results