Q&A about the site for finance professionals and academics
SELECT ts.SourceTagName AS [TagName], ts.TargetTagName AS [TagName], t2.Count, * FROM TagSynonyms ts LEFT OUTER JOIN Tags t ON t.TagName=ts.TargetTagName INNER JOIN Tags t2 ON t2.TagName=ts.SourceTagName WHERE t.Id IS NULL