Java vs Kotlin without Android

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results