Vine ViewCount by Post

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT 

  datepart(year, CreationDate) as 'year',
  id, ViewCount
  
FROM

(

  SELECT p.CreationDate, p.id, p.ViewCount FROM Posts p
    INNER JOIN PostTags pt ON p.Id = pt.PostId
    INNER JOIN Tags t ON t.Id = pt.TagId
  WHERE (p.PostTypeId = 1) AND (t.TagName = 'vine')
    and p.CreationDate between '2013-01-01' and '2020-12-31'
  
) as tb

ORDER BY 1 ASC, tb.CreationDate ASC;

Enter Parameters

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