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.

Martial Arts Meta

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 Year(creationdate), Month(creationdate), sum(drep) as drep from A
group by Year(creationdate), Month(creationdate)
order by Year(creationdate) desc , Month(creationdate) desc

Enter Parameters

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