Q&A for people looking to improve their interpersonal communication skills
-- Enter Query Title -- Enter Query Description SELECT p.Id, p.Title, t.TagName , RANK() OVER (PARTITION BY p.Id ORDER BY pt.TagId) FROM Posts p INNER JOIN PostTags pt ON pt.PostId=p.Id INNER JOIN Tags t ON pt.TagId=t.Id WHERE p.Id IN (SELECT id from Posts p JOIN PostTags pt on pt.PostId=p.id WHERE pt.TagId NOT IN (SELECT id FROM Tags WHERE TagName = 'usage')) ORDER BY p.Id, pt.TagId