Zero and non-zero accepted count. Self-accepted answers do not count.
Q&A about the site for students and teachers of all martial arts
-- How Unsung am I?
-- Zero and non-zero accepted count. Self-accepted answers do not count.
--select * from votetypes;
--select top 100 * from votes;
with A as (select p.id as [Post Link], v.creationdate, v.votetypeid,
case when votetypeid = 1 then 15 else case when votetypeid = 2 then 10 else -2 end end as drep
from votes v inner join posts p on v.postid = p.id
where v.votetypeid<4 and
p.owneruserid = 2093077)
select creationdate, sum(drep) from A
group by creationdate
order by creationdate desc