Q&A about the site for Tridion developers and administrators
SELECT TOP 100 * FROM Posts INNER JOIN Users ON Posts.OwnerUserId = Users.Id WHERE Posts.CreationDate >= '2019-01-01' AND Posts.CreationDate < '2020-01-01' AND Posts.PostTypeId = 1 AND Users.Reputation >= 80000 ORDER BY Score DESC;