Q&A for gardeners and landscapers
SELECT datepart(year,creationdate), count(*) FROM users --where datepart(year,creationdate) = 2008 group by datepart(year,creationdate) select datepart(year,creationdate), count(distinct OwnerUserId) as OwnerUserId from Posts where OwnerUserId in (SELECT Id FROM users where datepart(year,creationdate) = 2008) and posttypeid = 1 and datepart(year,creationdate) = 2008 and OwnerUserId is not null group by datepart(year,creationdate) --having count(*) > 5