Q&A about the site for professional robotic engineers, hobbyists, researchers and students
SELECT TOP 10 COUNT(*) AS QuestionCount, TagName FROM Posts Question JOIN PostTags ON PostTags.PostId = Question.Id JOIN Tags ON Tags.Id = PostTags.TagId WHERE TagName IN ('java', 'kotlin') AND PostId NOT IN ( SELECT PostId FROM PostTags JOIN Tags ON Tags.Id = PostTags.TagId WHERE TagName = 'android' ) AND Question.CreationDate < DATEFROMPARTS(YEAR(GETDATE()) + 1, 1, 1) AND Question.CreationDate > DATEFROMPARTS(YEAR(GETDATE()), 1, 1) GROUP BY TagName ORDER BY QuestionCount DESC