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 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-_._'

/*
UNION ALL
SELECT 
  [Language] = 'Java',
  TagName
FROM Tags
WHERE TagName LIKE 'java-_' OR TagName LIKE 'java-1_'
UNION ALL
SELECT 
  [Language] = 'C#',
  TagName
FROM Tags
WHERE TagName LIKE 'c#-_._'
ORDER BY [Language], TagName
*/
GROUP BY t.TagName
ORDER BY [Language], TagName

Enter Parameters

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