0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

select v.CreationDate time , 
       cast(p.id as char) post,
       --(5-2.00*v.votetypeid) vote,
       sum(5-2.00*v.votetypeid) 
          over (partition by p.id order by p.id, v.CreationDate
                ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) score
from posts p join votes v 
on p.id = v.PostId
where p.ParentID = 398871 and p.PostTypeId = 2 and v.votetypeid in (2,3)
order by p.id, v.CreationDate

view current version

edited nov 20 19

created nov 20 19 anonymous