Votes on questions and answers for [rust] per day averaged over months since 2013

1

Please login or register to vote for this query.

(click on this box to dismiss)

Blender Meta

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

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

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

Enter Parameters

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