Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language
SELECT TOP 200 ViewCount, Posts.Id AS [Post Link], Tags, Title, AnswerCount, CreationDate FROM Posts INNER JOIN PostTags ON PostTags.PostId = Posts.Id INNER JOIN Tags ON PostTags.TagId = Tags.Id WHERE CreationDate > DATEADD(year, -1, GETDATE()) /* '2010/01/01' */ AND Tags.TagName like 'firebase%' ORDER BY ViewCount DESC;