It will gives you Top 300 Users who belongs to India.
Q&A for serious players and enthusiasts of chess
SELECT TOP 500
ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
LOWER(Location) LIKE '%india%'
OR UPPER(Location) LIKE '%IND'