Q&A for dedicated home brewers and serious enthusiasts
with new as( select t.TagName name, count(p.Id) cnt from Posts p join PostTags pt on p.Id=pt.PostId join Tags t on pt.TagId=t.Id where p.Tags like '%<mysql>%' and t.TagName <>'my sql' group by t.TagName) select name, cnt from new /*where cnt = (select max(cnt) from new)*/