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 TOP 20
    TargetTagName AS [Tag], 
    COUNT(SourceTagName) AS [Synonym Count]
FROM
    TagSynonyms
WHERE
    ApprovalDate IS NOT NULL
GROUP BY
    TargetTagName
ORDER BY
    [Synonym Count] DESC;

view current version

edited may 8 12

created may 8 12 BoltClock