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 500 * from users u inner join locations l on u.location = l.location where rn between 70 and 80