instruction: Average number of questions per day, over a week - about Apache Beam + Stack Overflow.
response: SELECT MIN(Posts.CreationDate) AS period, SUM(CASE WHEN Posts.PostTypeId = 1 THEN 1 ELSE 0 END) AS "questions per month" FROM Posts WHERE Posts.PostTypeId = 1 AND (Posts.Tags LIKE '%apache-beam%' OR Posts.Tags LIKE '%google-cloud-dataflow%') GROUP BY TIME_TO_STR(Posts.CreationDate, '%m'), TIME_TO_STR(Posts.CreationDate, '%Y') ORDER BY period