High Reputation Users Who are Also Tenacious

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

-- Who is most 'tenacious' of them all?


/*SELECT b.UserId, max(b.Date) DateReceived, u.DisplayName, u.*
FROM Users u, Badges b
WHERE b.name='java'
and u.Id=b.UserId
and u.Location like '%India%'
GROUP BY b.UserId, u.DisplayName
HAVING COUNT(*)>2
ORDER BY DateReceived */

SELECT
DISTINCT u.Id, u.Reputation, u.DisplayName
FROM
  Users u, Badges b
WHERE
  b.name = 'Tenacious'
  and u.Id = b.UserId
  and u.Reputation > 0
ORDER BY u.reputation desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results