0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for serious players and enthusiasts of chess

SELECT DISTINCT CONCAT('https://stackoverflow.com/users/', u.Id) AS [Profile Link], u.Id, u.DisplayName, u.Reputation, p.Name
FROM Users AS u
JOIN Badges AS b ON b.UserId = u.Id
JOIN (
   SELECT OwnerUserId, Tags, pt.Name
   FROM Posts AS p
   JOIN PostTypes AS pt
   ON p.PostTypeId = pt.Id
   WHERE pt.Name = 'Answer'
) AS p ON p.OwnerUserId = u.Id
WHERE LOWER(u.location) LIKE '%sanfrancisco%'
   AND LOWER(b.Name) LIKE 'go'
ORDER BY Reputation DESC;

fork query

edited aug 4

created aug 4 anonymous