Q&A for enthusiasts and power users of the Android operating system
select u.Id as "UserId", u.DisplayName as "Name", p.Id as "PostId", DATEPART(YEAR, p.CreationDate) as PostYear, DATEPART(MONTH, p.CreationDate) as PostMonth, DATEPART(DAY, p.CreationDate) as PostDAY, DATEPART(YEAR, p2v.CreationDate) as VoteYear, DATEPART(MONTH, p2v.CreationDate) as VoteMonth, DATEPART(DAY, p2v.CreationDate) as VoteDAY, SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) as "upvotes", SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) as "downvotes", u.Reputation as "Rep", u.Age from Votes p2v join Posts p on p2v.PostId = p.Id join Users u on p.OwnerUserId = u.Id where u.Id in ( 5651,5651 ) and p.PostTypeId = 2 GROUP BY u.Id, u.DisplayName, p.Id, DATEPART(YEAR, p.CreationDate), DATEPART(MONTH, p.CreationDate),DATEPART(DAY, p.CreationDate),DATEPART(YEAR, p2v.CreationDate), DATEPART(MONTH, p2v.CreationDate),DATEPART(DAY, p2v.CreationDate), u.Reputation, u.Age having CAST(DATEPART(DAY, p2v.CreationDate) as float)*1 - CAST(DATEPART(DAY, p.CreationDate) as float)*1 + CAST(DATEPART(MONTH, p2v.CreationDate) as float)*30 - CAST(DATEPART(MONTH, p.CreationDate) as float)*30 + CAST(DATEPART(YEAR, p2v.CreationDate) as float)*365 - CAST(DATEPART(YEAR, p.CreationDate) as float)*365 <=60 ORDER BY u.Id,p.Id, PostYear, PostMonth, VoteYear, VoteMonth ASC