select top 100 location from users where creationdate >= ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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

Enter Parameters

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