0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Top Users by Country
-- Created by samliew (http://stackoverflow.com/users/584192/samuel-liew)

SELECT
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation
FROM
    Users
WHERE
    UPPER(Users.Location) LIKE '%GERMAN%'
    OR UPPER(Users.Location) LIKE '% DE'
    OR UPPER(Users.Location) LIKE '%BERLIN%'
    OR UPPER(Users.Location) LIKE '%MÜNCHEN%'
    OR UPPER(Users.Location) LIKE '%MUNICH%'
    OR UPPER(Users.Location) LIKE '%NÜRNBERG%'
    OR UPPER(Users.Location) LIKE '%NUREMBERG%'
    OR UPPER(Users.Location) LIKE '%STUTTGART%'
    OR UPPER(Users.Location) LIKE '%ESSLINGEN%'
    OR UPPER(Users.Location) LIKE '%TÜBINGEN%'
    OR UPPER(Users.Location) LIKE '%TUBINGEN%'
    OR UPPER(Users.Location) LIKE '%REUTLINGEN%'
    OR UPPER(Users.Location) LIKE '%KARLSRUHE%'
    OR UPPER(Users.Location) LIKE '%HEIDELBERG%'
    OR UPPER(Users.Location) LIKE '%KÖLN%'
    OR UPPER(Users.Location) LIKE '%COLOGNE%'
    OR UPPER(Users.Location) LIKE '%POTSDAM%'
    OR UPPER(Users.Location) LIKE '%HAMBURG%'
    OR UPPER(Users.Location) LIKE '%HANNOVER%'
    OR UPPER(Users.Location) LIKE '%DÜSSELDORF%'
    OR UPPER(Users.Location) LIKE '%DUSSELDORF%'
    OR UPPER(Users.Location) LIKE '%DARMSTADT%'
    OR UPPER(Users.Location) LIKE '%FRANKFURT%'
    OR UPPER(Users.Location) LIKE '%FREIBURG%'
    OR UPPER(Users.Location) LIKE '%DRESDEN%'
    OR UPPER(Users.Location) LIKE '%LEIPZIG%'
    OR UPPER(Users.AboutMe) LIKE  '%GERMAN%'
    OR UPPER(Users.AboutMe) LIKE '% DE'
    OR UPPER(Users.AboutMe) LIKE '%BERLIN%'
    OR UPPER(Users.AboutMe) LIKE '%MÜNCHEN%'
    OR UPPER(Users.AboutMe) LIKE '%MUNICH%'
    OR UPPER(Users.AboutMe) LIKE '%NÜRNBERG%'
    OR UPPER(Users.AboutMe) LIKE '%NUREMBERG%'
    OR UPPER(Users.AboutMe) LIKE '%STUTTGART%'
    OR UPPER(Users.AboutMe) LIKE '%ESSLINGEN%'
    OR UPPER(Users.AboutMe) LIKE '%TÜBINGEN%'
    OR UPPER(Users.AboutMe) LIKE '%TUBINGEN%'
    OR UPPER(Users.AboutMe) LIKE '%REUTLINGEN%'
    OR UPPER(Users.AboutMe) LIKE '%KARLSRUHE%'
    OR UPPER(Users.AboutMe) LIKE '%HEIDELBERG%'
    OR UPPER(Users.AboutMe) LIKE '%KÖLN%'
    OR UPPER(Users.AboutMe) LIKE '%COLOGNE%'
    OR UPPER(Users.AboutMe) LIKE '%POTSDAM%'
    OR UPPER(Users.AboutMe) LIKE '%HAMBURG%'
    OR UPPER(Users.AboutMe) LIKE '%HANNOVER%'
    OR UPPER(Users.AboutMe) LIKE '%DÜSSELDORF%'
    OR UPPER(Users.AboutMe) LIKE '%DUSSELDORF%'
    OR UPPER(Users.AboutMe) LIKE '%DARMSTADT%'
    OR UPPER(Users.AboutMe) LIKE '%FRANKFURT%'
    OR UPPER(Users.AboutMe) LIKE '%FREIBURG%'
    OR UPPER(Users.AboutMe) LIKE '%DRESDEN%'
    OR UPPER(Users.AboutMe) LIKE '%LEIPZIG%'
ORDER BY
    Reputation DESC;

fork query

created mar 16 13 Tim Schmelter