instruction: Which questions have their tags in the title or body (Sept 2020)?.
response: SELECT p.Id, p.Tags, t.TagName, CASE WHEN p.Title LIKE '%' + t.TagName + '%' THEN 'In Title' WHEN p.Body LIKE '%' + t.TagName + '%' THEN 'In Question' ELSE NULL END AS "tag_location", p.CreationDate FROM Posts AS p INNER JOIN PostTypes AS ptypes ON p.PostTypeId = ptypes.Id AND ptypes.Name = 'Question' INNER JOIN PostTags AS ptags ON p.Id = ptags.PostId INNER JOIN Tags AS t ON t.Id = ptags.TagId INNER JOIN (SELECT TagName FROM Tags ORDER BY Count DESC LIMIT 10) AS top_tags ON t.TagName = top_tags.TagName WHERE (p.Title LIKE '%' + t.TagName + '%' OR p.Body LIKE '%' + t.TagName + '%') AND p.CreationDate BETWEEN '2020-09-01' AND '2020-09-30' ORDER BY p.Id