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)

Ask Ubuntu

Q&A for Ubuntu users and developers

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 meta site
loading Hold tight while we fetch your results