1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

select 
   --Posts.Id, Posts.Score, VoteTypeId, Votes.CreationDate
   min(Votes.CreationDate),
   (COUNT(*) + 0.0) / DATEPART(day, EOMONTH(MIN(Votes.CreationDate))) 
       as 'votes per day'
   
from Posts
    inner join PostTags 
        on PostTags.PostId = Posts.Id --OR PostTags.PostId = Posts.ParentId
    inner join Votes on Votes.PostId = Posts.Id
where
    (VoteTypeId = 2 OR VoteTypeId = 3) AND
    PostTags.TagId = 59148 AND -- that's 'rust'
    Votes.CreationDate > '2013-01-01'

GROUP BY 
    DATEPART(month, Votes.CreationDate), 
    DATEPART(year, Votes.CreationDate)
ORDER BY MIN(Votes.CreationDate)

view current version

edited jun 21

created jun 21 Lukas.Kalbertodt