Q&A for professionals and students of engineering
-- #1 user from Tanur, Kerala, India SELECT * FROM Users WHERE LOWER(Location) LIKE '%india%' OR UPPER(Location) LIKE '%INDIA%' or Location like '%India%' AND Reputation >= 1000 ORDER BY Reputation DESC;