example

0

Please login or register to vote for this query.

(click on this box to dismiss)

Esperanto Language

Q&A for teachers and students of the Esperanto language

select count(*)
from badges as aa
right join ( select count  ( b.id) as total,a.id, displayname, userid,
       ROW_NUMBER() OVER(
              ORDER BY count  ( b.id) desc
          ) row_num
      from users a
      join badges b
      on a.id=b.userid
      where location='South Africa'
      group by a.id, displayname,userid )as bb
    on aa.userid=bb.userid
    and name='Enlightened'
where   row_num=1

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results