shutterstock

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computer Science Educators

Q&A for those involved in the field of teaching Computer Science

SELECT TOP 1000
 TagTotals.TagName,
 Sum(TagTotals.Count) AS Total
FROM(
 SELECT
   TagSynonyms.TargetTagName as TagName,
   Tags.Count
 FROM
   Tags
     INNER JOIN
   TagSynonyms ON (
     Tags.TagName = TagSynonyms.SourceTagName
   )
 UNION ALL
 SELECT
   Tags.TagName,
   Tags.Count
 FROM
   Tags
     LEFT JOIN
   TagSynonyms ON (
     Tags.TagName = TagSynonyms.SourceTagName
   )
 WHERE
   TagSynonyms.SourceTagName IS NULL
 ) as TagTotals
GROUP BY TagTotals.TagName
ORDER BY Total DESC;

Enter Parameters

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