Q&A for pro webmasters
/*select top 50 * from Posts where PostTypeId = 1 and CAST(ClosedDate AS DATE) >= '2021-09-01' and CAST(ClosedDate AS DATE) < '2021-10-01' order by score desc */ select top 100 * from Badges