Number of posts per viewcount after august 2013

0

Please login or register to vote for this query.

(click on this box to dismiss)

Count number of posts with similar ViewCount, beginning from August 2013

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

Select ViewCount, count(Id) As NumPosts 
From posts p Where 
    ViewCount is not null and posttypeid =1 and 
    CreationDate>=datefromparts(2013, 8, 1) 
Group By ViewCount 
Order By ViewCount Desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results