https://meta.stackexchange.com/questions/278800/what-effect-do-post-notices-have-on-answer-voting
Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
select pn.postid , sum(case when v.votetypeid = 2 and v.creationdate < pn.creationdate then 1 else 0 end ) [upvotes before notice] , sum(case when v.votetypeid = 2 and v.creationdate >= pn.creationdate then 1 else 0 end ) [upvotes after notice] , sum(case when v.votetypeid = 3 and v.creationdate < pn.creationdate then 1 else 0 end ) [downvotes before notice] , sum(case when v.votetypeid = 3 and v.creationdate >= pn.creationdate then 1 else 0 end ) [downvotes after notice] from postnotices pn inner join postnoticetypes pnt on pnt.id = pn.postnoticetypeid left outer join votes v on v.postid = pn.postid where postnoticetypeid in (1,3) and v.votetypeid in (2,3) group by pn.postid select * from postnoticetypes