instruction: Top Trending Windows 8 Questions - Less than 2 answers.
response: SELECT DISTINCT LastActivityDate, ViewCount, Title, p.CreationDate, AnswerCount, 'http://stackoverflow.com/questions/' + CAST(p.Id AS VARCHAR(255)) FROM Posts AS p JOIN PostTags AS pt ON pt.PostId = p.Id JOIN Tags AS t ON t.Id = pt.TagId WHERE t.TagName IN ('windows-8', 'microsoft-metro', 'metro-style-app', 'windows-store-apps') AND (CreationDate BETWEEN DATEADD(day, -30, GETDATE()) AND GETDATE() AND ClosedDate IS NULL) ORDER BY ViewCount DESC, AnswerCount DESC