Q&A about the site for speakers of other languages learning English
SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Users.Reputation DESC) AS [#], Users.Id AS [User Link], Users.Age, Users.Location, Users.Reputation, Users.UpVotes, Users.DownVotes, (SELECT COUNT(*) FROM Posts AS PQ WHERE PostTypeId = 1 AND PQ.OwnerUserId = Users.Id) AS [Questions], (SELECT COUNT(*) FROM Posts AS PA WHERE PostTypeId = 2 AND PA.OwnerUserId = Users.Id) AS [Answers] FROM Users WHERE UPPER(Users.Location) LIKE '%LANKA%' OR UPPER(Users.Location) LIKE '%COLOMBO%' OR UPPER(Users.Location) LIKE '%KANDY%' AND Users.Reputation < 400 ORDER BY Reputation DESC;