with locations as ( select location , count(1) cnt , row_...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

with locations as (
select location
, count(1) cnt
, row_number() over(order by count(1) desc) rn
from users
where len(location) >= 0
group by location
)
select top 10 *
from users u
inner join locations l on u.location = l.location
where rn between 70 and 80

Enter Parameters

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