Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
SELECT OwnerUserId, COUNT(*) FROM Posts WHERE YEAR(CreationDate) = 2017 GROUP BY OwnerUserId;