Q&A about the site for members of the workforce navigating the professional setting
SELECT TOP 2000 ROW_NUMBER() OVER(ORDER BY Users.Reputation DESC) AS [#], Users.Id AS [User Link], Users.Location, Users.Reputation, Users.Views, 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%' ORDER BY Reputation DESC;