;with cte as ( select FORMAT(convert(date, P.CreationDate...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

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

;with cte as (
  select
  FORMAT(convert(date, P.CreationDate), 'yyyy-MM-01 00:00:00.000') [date],
  P.ViewCount,
  P.Tags,
  P.AnswerCount

  from Posts P
  join PostTypes PT on PT.id = P.PostTypeId

  where
  PT.Name in ('Question')
  and Tags like '%##contents##%'
)

select
[date],
sum(ViewCount) ViewCount

from cte

group by
[date]

order by [date] desc

Enter Parameters

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