Get top users in Lithuania

0

Please login or register to vote for this query.

(click on this box to dismiss)

Get top users by country

Computational Science

Q&A for scientists using computers to solve scientific problems

SELECT DISTINCT U.Reputation, U.Id AS [User Link], U.Views
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 (P.Tags LIKE '%C#%' OR P.Tags LIKE '%MVC%')
ORDER BY
    Reputation DESC;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results