0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

select top 100 p.id as [Post Link]
, sum(case 
      when v.votetypeid = 2 
      then 1.0 * (1.0 / (datediff(day, v.creationdate, getdate()) + 1)) 
      else null end) 
from posts p 
inner join votes v on v.postid = p.id
where v.votetypeid = 2 
group by p.id
order by 2

view current version

edited jan 21

created jan 21 rene