Q&A for Tridion developers and administrators
select top 50 * from Posts where PostTypeId = 1 and CAST(ClosedDate AS DATE) >= '2021-09-01' and CAST(ClosedDate AS DATE) < '2021-10-01' and posts.OwnerUserId IN ( select distinct UserId from Badges ) order by score desc