SELECT p.OwnerUserId as UserId, DATENAME(Year, v.Creation...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

SELECT 
    p.OwnerUserId as UserId,
    DATENAME(Year, v.CreationDate) as Year,
    DATENAME(Month, v.CreationDate) as Month,
    SUM(CASE WHEN v.VoteTypeId = 2 THEN 1 ELSE 0 END) AS UpVotes,
    SUM(CASE WHEN v.VoteTypeId = 3 THEN 1 ELSE 0 END) AS DownVotes,
    SUM(CASE WHEN v.VoteTypeId in (1,5) THEN 1 ELSE 0 END) AS FavoriteVotes,
    SUM(CASE WHEN v.VoteTypeId in (4,6,10,12) THEN 1 ELSE 0 END) AS PeeveVotes
FROM Posts as p
inner join Votes v ON v.PostId=p.Id
where p.owneruserid in ('16007','182668','134554','223992','9204','15416','3501','65863','139985','179910','252228','225074','7432','3043','143305','218196','22656','87189','69545','107090','50617','2988','65387','149392','33518','23354','6309','13508','1338','115145','18771','14860','476','131930','16406','15168','146325','89817','140750','13302','1968','19068')
GROUP BY p.OwnerUserId, DATENAME(Year, v.CreationDate), DATENAME(Month, v.CreationDate)
ORDER BY p.OwnerUserId

Enter Parameters

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