;with gqlTags as ( select FORMAT(convert(date, P.Creation...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

;with gqlTags 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 '%graphql%'
)

select
[date],
sum(ViewCount) ViewCount

from gqlTags

group by
[date]

order by [date] desc

Enter Parameters

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