Question asking badges


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for Joomla! administrators, users, developers and designers

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(*)

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results