0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

select DATEADD(DAY, DATEDIFF(DAY, 0, creationdate), 0) date, 'PHP' programming_language,
sum(case when tags like '%php%' then 1 else 0 end) question_count
  from posts 
    where posttypeid = 1
      and creationdate < '2020-08-01'
        and creationdate >= '2020-07-01'
        group by DATEADD(DAY, DATEDIFF(DAY, 0, creationdate), 0)

view current version

edited aug 5 20

created aug 5 20 jon.doe33167