how long before I get tag badges?
Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
WITH counts AS ( select users.id as ui,users.reputation as up,count( *)as posts_num from posts,users where posts.owneruserid=users.id and users.creationdate<='2020-09-15' and posts.creationdate <='2021-09-16' and posts.creationdate >='2021-08-15' group by users.id,users.reputation ) select users.*,posts_num from users,counts where users.id=counts.ui and posts_num >=20 and posts_num <=500 order by posts_Num desc