How Unsung am I?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Zero and non-zero accepted count. Self-accepted answers do not count.

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

-- 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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results