Top Users by Country

0

Please login or register to vote for this query.

(click on this box to dismiss)

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

Open Data

Q&A for developers and researchers interested in open data

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

SELECT 
    Location, 
    AVG(Reputation)
FROM
    Users
    WHERE Location LIKE '%London%' OR Location LIKE '%Berlin%' OR Location LIKE '%Madrid%' OR Location LIKE '%Rome%' OR Location LIKE '%Paris%' OR Location LIKE '%Bucharest%' OR Location LIKE '%Budapest%' OR Location LIKE '%Hamburg%' OR Location LIKE '%Warsaw%' OR Location LIKE '%Vienna%' OR Location LIKE '%Barcelona%' OR Location LIKE '%Stockholm%' OR Location LIKE '%Munich%' OR Location LIKE '%Milan%' OR Location LIKE '%Prague%' OR Location LIKE '%Copenhagen%' OR Location LIKE '%Sofia%' OR Location LIKE '%Dublin%' OR Location LIKE '%Brussels%' OR Location LIKE '%Birmingham%' OR Location LIKE '%Cologne%' OR Location LIKE '%Naples%' OR Location LIKE '%Turin%' OR Location LIKE '%Liverpool%' OR Location LIKE '%Valencia%' OR Location LIKE '%Marseille%' OR Location LIKE '%Lodz%' OR Location LIKE '%Krakow%' OR Location LIKE '%Riga%' OR Location LIKE '%Amsterdam%' OR Location LIKE '%Nottingham%' OR Location LIKE '%Sevilla%' OR Location LIKE '%Zagreb%' OR Location LIKE '%Sheffield%' OR Location LIKE '%Saragossa%' OR Location LIKE '%Athens%' OR Location LIKE '%Frankfurt am Main%' OR Location LIKE '%Palermo%' OR Location LIKE '%Wroclaw%' OR Location LIKE '%Bristol%' OR Location LIKE '%Rotterdam%' OR Location LIKE '%Essen%' OR Location LIKE '%Glasgow%' OR Location LIKE '%Stuttgart%' OR Location LIKE '%Dortmund%' OR Location LIKE '%Genoa%' OR Location LIKE '%Duesseldorf%' OR Location LIKE '%Gothenburg%' OR Location LIKE '%Poznan%' OR Location LIKE '%Malaga%' OR Location LIKE '%Helsinki%' OR Location LIKE '%Bremen%' OR Location LIKE '%Vilnius%' OR Location LIKE '%Lisbon%' OR Location LIKE '%Hannover%' OR Location LIKE '%Leicester%' OR Location LIKE '%Leipzig%' OR Location LIKE '%Duisburg%' OR Location LIKE '%Nuernberg%' OR Location LIKE '%Dresden%' OR Location LIKE '%The Hague%' OR Location LIKE '%Lyon%' OR Location LIKE '%Edinburgh%' OR Location LIKE '%Gdansk%' OR Location LIKE '%Antwerpen%' OR Location LIKE '%Leeds%' OR Location LIKE '%Cardiff%' OR Location LIKE '%Murcia%' OR Location LIKE '%Toulouse%' OR Location LIKE '%Bratislava%' OR Location LIKE '%Szczecin%' OR Location LIKE '%Palma%' OR Location LIKE '%Manchester%' OR Location LIKE '%Tallinn%' OR Location LIKE '%Bochum%' OR Location LIKE '%Las Palmas de Gran Canaria%' OR Location LIKE '%Kaunas%' OR Location LIKE '%Stoke-on-Trent%' OR Location LIKE '%Brno%' OR Location LIKE '%Bydgoszcz%' OR Location LIKE '%Bologna%' OR Location LIKE '%Wuppertal%' OR Location LIKE '%Lublin%' OR Location LIKE '%Coventry%' OR Location LIKE '%Bilbao%' OR Location LIKE '%Thessaloniki%' OR Location LIKE '%Florence%' OR Location LIKE '%Plovdiv%' OR Location LIKE '%Nice%' OR Location LIKE '%Sunderland%' OR Location LIKE '%Alicante%' OR Location LIKE '%Bielefeld%' OR Location LIKE '%Cordoba%' OR Location LIKE '%Birkenhead%' OR Location LIKE '%Islington%' OR Location LIKE '%Reading%' OR Location LIKE '%Iasi%' OR Location LIKE '%Valladolid%' OR Location LIKE '%Katowice%' OR Location LIKE '%Cluj-Napoca%' OR Location LIKE '%Timisoara%'
GROUP BY
Location

Enter Parameters

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