how long before I get tag badges?
Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
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 >=50 and posts_num <=100