0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for vintage-computer hobbyists interested in restoring, preserving, and using the classic computer and gaming systems of yesteryear

select
pt.Name AS POST_TYPE
,count(distinct p.id) as unique_post_count
from Posts p 
left join PostTypes pt on p.PostTypeId = pt.Id
where 1=1
and YEAR(p.ClosedDate) = 2022 
Group by pt.Name
order by pt.Name

fork query

edited mar 4

created mar 4 anonymous