Q&A about the site for people who use Blender to create 3D graphics, animations, or games
select pt.Name AS POST_TYPE ,count(distinct p.id) as unique_post_count from Posts p left join PostTypes pt on p.Id = pt.Id Group by pt.Name