Q&A about the site for vintage-computer hobbyists interested in restoring, preserving, and using the classic computer and gaming systems of yesteryear
select pt.Name AS POST_TYPE ,count(distinct p.id) as unique_post_count from Posts p left join PostTypes pt on p.PostTypeId = pt.Id Group by pt.Name