instruction: Activity on Stack by Time.
response: SELECT COUNT(p.Id) AS count_of_feature, DATE(p.CreationDate) AS datetime, t.Name AS name FROM Posts AS p INNER JOIN PostTypes AS t ON p.PostTypeId = t.Id LEFT JOIN Posts AS pp ON p.ParentId = pp.Id WHERE (p.Tags LIKE '%##tagname##%') OR (pp.Tags LIKE '%##tagname##%') GROUP BY DATE(p.CreationDate), t.Name ORDER BY DATE(p.CreationDate)