Select PostTypes.Name, Count(Posts.Id) from Posts Join Po...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Blender

Q&A for people who use Blender to create 3D graphics, animations, or games

Select PostTypes.Name, Count(Posts.Id)
from Posts
Join PostTypes on PostTypes.Id = Posts.PostTypeId
Where Posts.CreationDate between '2017-1-1' and '2017-12-31'
Group By PostTypes.Name

Enter Parameters

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