0

Please login or register to vote for this query.

(click on this box to dismiss)

Finds the top 20 tags with the greatest number of approved synonyms that map to them.

Q&A for scientific skepticism

SELECT
    SourceTagName, 
    COUNT(TargetTagName) AS [Synonym Count]
FROM
    TagSynonyms
WHERE
    ApprovalDate IS NOT NULL
GROUP BY
    SourceTagName
ORDER BY
    [Synonym Count] DESC;

view current version

edited may 8 12

created may 8 12 BoltClock