Q&A for developers and researchers interested in open data
SELECT TOP 1000 Questions.Id AS [Post Link], Questions.Title, Questions.AnswerCount, Questions.ViewCount, Questions.FavoriteCount, Questions.Score, Questions.LastActivityDate, Questions.CreationDate ,DatePart(quarter, Questions.CreationDate) as q ,Questions.Tags FROM Posts AS Answers INNER JOIN Posts AS Questions ON Questions.Id = Answers.ParentId INNER JOIN Users AS Users ON Answers.OwnerUserId = Users.Id INNER JOIN PostTags ON PostTags.PostId = Answers.ParentId INNER JOIN Tags ON Tags.Id = PostTags.TagId WHERE Year(Questions.CreationDate) >= 2020 AND Month(Questions.CreationDate) = 5 AND Day(Questions.CreationDate) = 30 and charindex('java',Questions.Title)>0 and charindex('javascript',Questions.Title)=0 GROUP BY Questions.Id, Questions.Title, Questions.AnswerCount, Questions.ViewCount, Questions.FavoriteCount, Questions.Score, Questions.LastActivityDate, Questions.CreationDate, Questions.Tags ORDER BY AnswerCount DESC