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

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 =2 and 
    CreationDate>=datefromparts(2013, 8, 15) Group By ViewCount

view current version

edited sep 1 13

created sep 1 13 anonymous