1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select 
cast(p.CreationDate as Date) Date,
sum(case when u.CreationDate > p.CreationDate - 2 then 1 else 0 end)
/ (count(*) + 0.0) [Ratio]
from Posts p
join Users u on u.Id = p.OwnerUserId
where PostTypeId = 1
group by cast(p.CreationDate as Date)
order by cast(p.CreationDate as Date) asc

fork query

edited may 9 12

created may 9 12 sam.saffron