Stack Exchange
log in help

select pt.name, count(*) from posts p join posttypes pt o...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

select pt.name, count(*)
from posts p join posttypes pt on p.posttypeid=pt.id
where year(creationdate)=2022
group by  pt.name
order by pt.name;
fork query

Enter Parameters

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