Q&A about the site for serious players and enthusiasts of poker
with user_questions as ( select count(*) number_asked from Posts where score > 0 and PostTypeId = 1 and OwnerUserId is not null group by OwnerUserId ), badges as ( select case when number_asked > 50 then 'gold' when number_asked > 10 then 'silver' when number_asked > 1 then 'bronze' else 'none' end badge_type from user_questions ) select count(*), badge_type from badges group by badge_type order by count(*)