Q&A for those involved in the field of teaching Computer Science
select PostTypeId ,count(distinct id) as unique_post_count from Posts Group by PostTypeId