0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select top 100 location, reputation, count(*)
  from users
  where creationdate >= '2020-01-01' and (
      location like '%Russia%' or 
      location like N'%Россия%'
    )
  group by location, reputation
  having count(*) > 10
  order by reputation;

view current version

edited oct 7

created oct 7 jon.doe37112