Q&A for network engineers
select p.Id, count(p.Id) from PostTags pt join Posts p on pt.PostId = p.Id group by p.Id