2

Please login or register to vote for this query.

(click on this box to dismiss)

Shows reputation from Latin American users. Also shows location and a couple of additional South American countries.

Q&A for Ubuntu users and developers

SELECT Reputation, DisplayName, Location FROM Users WHERE (Location 
LIKE '%Argentina%' OR Location 
LIKE '%Belize%' OR Location 
LIKE '%Bolivia%' OR Location 
LIKE '%Brazil%' OR Location 
LIKE '%Chile%' OR Location 
LIKE '%Colombia%' OR Location 
LIKE '%Costa Rica%' OR Location 
LIKE '%Cuba%' OR Location 
LIKE '%Dominican Republic%' OR Location 
LIKE '%Republica Dominicana%' OR Location 
LIKE '%Ecuador%' OR Location 
LIKE '%El Salvador%' OR Location 
LIKE '%Guatemala%' OR Location 
LIKE '%Guyana%' OR Location 
LIKE '%Haiti%' OR Location 
LIKE '%Honduras%' OR Location 
LIKE '%Jamaica%' OR Location 
LIKE '%Mexico%' OR Location 
LIKE '%Nicaragua%' OR Location 
LIKE '%Panama%' OR Location 
LIKE '%Paraguay%' OR Location 
LIKE '%Peru%' OR Location 
LIKE '%Puerto Rico%' OR Location 
LIKE '%Uruguay%' OR Location 
LIKE '%Spain%' OR Location 
LIKE '%Venezuela%' OR Location
LIKE '%MX%') AND Location
NOT LIKE '%New Mexico%' AND Reputation > 101
ORDER BY Reputation DESC

fork query

edited apr 14 16

created aug 27 12 Luis Alvarado