Versioned Language Tags (Java, C#, Python)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
  [Language] = 'Python',
  t.TagName,
  [Posts] = COUNT(pt.PostId)
FROM Tags AS t
JOIN PostTags AS pt
  ON t.Id = pt.TagId
WHERE t.TagName LIKE 'python-_._'
GROUP BY t.TagName
UNION ALL
SELECT 
  'Java',
  t.TagName,
  COUNT(pt.PostId)
FROM Tags AS t
JOIN PostTags AS pt
  ON t.Id = pt.TagId
WHERE TagName LIKE 'java-_' OR TagName LIKE 'java-1_'
GROUP BY t.TagName
UNION ALL
SELECT 
  'C#',
  t.TagName,
  COUNT(pt.PostId)
FROM Tags AS t
JOIN PostTags AS pt
  ON t.Id = pt.TagId
WHERE TagName LIKE 'c#-_._'
GROUP BY t.TagName
ORDER BY [Language], TagName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results