instruction: how to view active history for the specific day for specific tag. http://meta.stackoverflow.com/questions/329611/how-to-view-active-history-for-the-specific-day-for-specific-tag
response: SELECT DISTINCT p.Id AS "post_link", CASE WHEN p.PostTypeId = 1 THEN 'Q' ELSE 'A' END AS qa, p.CreationDate, p.Score, p.OwnerUserId AS "user_link" FROM Posts AS p INNER JOIN PostTags AS pt ON pt.PostId = COALESCE(p.ParentId, p.Id) INNER JOIN Tags AS t ON t.Id = pt.TagId INNER JOIN PostHistory AS ph ON ph.PostId = p.Id WHERE t.TagName = '##tag:string##' AND ph.CreationDate BETWEEN '##date:string##' AND DATEADD(d, 1, CAST('##date:string##' AS DATE))