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