Q&A for professional and enthusiast programmers
SELECT Distinct u.Id AS [User Link], CONCAT('https://stackoverflow.com/users/', u.Id) AS [Profile Link], u.DisplayName, u.Location, u.WebsiteUrl, u.AboutMe, u.Views, u.UpVotes, u.DownVotes, u.EmailHash, u.Reputation FROM Users u WHERE Upper(u.AboutMe) LIKE Upper('%##RoleName##%') Order By u.Reputation DESC;