Q&A for experienced flyers, pilots, and builders of drones and model aircraft
SELECT TOP 1 U.DisplayName, COUNT(P.Id) AS PostCount FROM Posts P JOIN Users U ON P.OwnerUserId = U.Id WHERE YEAR(P.CreationDate) = 2017 GROUP BY U.DisplayName ORDER BY PostCount DESC;