instruction: How popular are Python, R and SAS.
response: SELECT YEAR(q.CreationDate) AS Year, MONTH(q.CreationDate) AS Month, t.TagName, COUNT(DISTINCT q.Id) AS countOfPosts, COUNT(*) AS c, SUM(q.ViewCount) AS countOfViews FROM PostTags AS pt JOIN Posts AS q ON q.Id = pt.PostId JOIN Tags AS t ON t.Id = pt.TagId WHERE t.TagName IN ('sas', 'python', 'r') GROUP BY YEAR(q.CreationDate), MONTH(q.CreationDate), t.TagName