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)