Russian-speaking users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

with UsersRussian as (
  select
    *
  from
    Users
  where
    Location like N'%russia%'
    or Location like N'%Russia%'
    or Location like N'%росси%'
    or Location like N'%Росси%'
    or Location like N'%ukraine%'
    or Location like N'%Ukraine%'
    or Location like N'%украин%'
    or Location like N'%Украин%'
    or Location like N'%belarus%'
    or Location like N'%Belarus%'
    or Location like N'%беларус%'
    or Location like N'%Беларус%'
    or Location like N'%белорус%'
    or Location like N'%Белорус%'
)

select
  count(Id) as [Count],
  sum(Reputation) as [Reputation],
  Location as [Location]
from
  UsersRussian
group by
  Location
  
union

select
  count(Id) as [Count],
  sum(Reputation) as [Reputation],
  'TOTAL' as [Location]
from
  UsersRussian

order by
  count(Id) desc

Enter Parameters

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