Нужна помощь с запросом sql

как-то так

With [data] as (
  select 
    users.id, 
    Year(posts.CreationDate) AS [Year]
  from 
      users 
      inner join posts 
        on posts.OwnerUserId = users.id
  group by 
   users.id
   , Year(posts.CreationDate)
    having 
    count(posts.id) > 60
)
SELECT 
    [Year], 
    Count(id) As numberOfUsers
FROM 
    [data]
group by 
  [Year]