Q&A about the site for gardeners and landscapers
SELECT TOP 1000 u.Id AS id, u.DisplayName AS display_name, Count(p.Id) AS posts FROM Posts p JOIN Users u ON u.Id = p.OwnerUserId JOIN PostTypes ty ON ty.Id = p.PostTypeId JOIN PostTags tg ON tg.PostId = p.Id JOIN Tags t ON t.Id = tg.TagId WHERE (t.TagName = 'python' OR t.TagName = 'r' OR t.TagName = 'java' OR t.TagName = 'scala' OR t.TagName = 'mysql' OR t.TagName = 'mongodb') AND ty.Name = 'Answer' AND p.CreationDate BETWEEN '20110601' AND '20140601' GROUP BY u.Id, u.DisplayName ORDER BY posts DESC