select pt.Name AS POST_TYPE ,count(distinct p.id) as uniq...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Blender Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results