Question asking badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

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

with user_questions as (
  select OwnerUserId, count(*) number_asked
  from Posts
  where score > 0
        and PostTypeId = 1
        and OwnerUserId is not null
  group by OwnerUserId
),

asking_badges as (
  select case 
           when number_asked >= 50 then 1
         end gold,
         case
           when number_asked >= 10 then 1
         end silver,
         case
           when number_asked >= 1  then 1
         end bronze,
         case
           when number_asked = 0  then 1
         end none
  from user_questions
       right join Users on OwnerUserId = Id
)

select count(*), sum(gold), sum(silver), sum(bronze), sum(none)
from asking_badges

Enter Parameters

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