Q&A for those who study, teach, research and apply economics and econometrics
-- Posts in a month Select u.DisplayName as Posts, Count(u.DisplayName) From Posts p Inner Join Users u On p.OwnerUserId = U.id Where p.OwnerUserId = 9778623 -- AND p.PostTypeId = 2 -- AND Year(p.CreationDate) = 2019 -- AND Month(p.CreationDate) = 10 Group By u.DisplayName ;