Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally
SELECT ext_t.TagName, COUNT(ext_pt.PostId) as PostCount
FROM PostTags ext_pt
INNER JOIN Tags ext_t ON ext_pt.TagId = ext_t.Id
WHERE ext_pt.PostId IN (
FROM Posts p
INNER JOIN PostTags pt ON p.Id = pt.PostId
INNER JOIN Tags t on pt.TagId = t.Id
WHERE t.TagName = 'jms'
AND t.TagName = 'ibm-mq'
GROUP BY ext_t.TagName
ORDER BY PostCount DESC