0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

select format(CreationDate, 'yyyy-MM-dd') CreationDate,
       count(*) as n
from Posts P
  inner join PostTags PT
    on P.Id = PT.PostId
  inner join Tags T
    on PT.TagId = T.Id
  inner join PostTypes PTy
    on P.PostTypeId = PTy.Id
where T.TagName = 'data.table' and
      PTy.Name = 'Question'
group by format(CreationDate, 'yyyy-MM-dd') order by CreationDate

fork query

edited apr 14 19

created apr 14 19 anonymous