0

Please login or register to vote for this query.

(click on this box to dismiss)

Get top users by country

Q&A for scientists using computers to solve scientific problems

SELECT TOP 100 U.Reputation, U.Id AS [User Link], U.Views, P.Tags
FROM Users U
  INNER JOIN Comments C ON C.UserId = U.Id
  INNER JOIN Posts P ON P.Id = C.PostId
WHERE LOWER(Location) like '%uruguay%' 
  --AND 
ORDER BY
    Reputation DESC;

fork query

edited oct 31 12

created jan 8 12 anonymous