Q&A for professional and enthusiast programmers
SELECT TOP 100 Rep, OwnerDisplayName, OwnerUserId, dt FROM ( SELECT SUM(Score) Rep, OwnerDisplayName, OwnerUserId, convert(varchar, CreationDate, 101) dt FROM Posts GROUP BY OwnerDisplayName, OwnerUserId, convert(varchar, CreationDate, 101) ) a --WHERE year(dt) = 2019 ORDER BY Rep DESC