Gold Java Badge Ranking in South Africa

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query retrieves all the gold java badge users and ranks them according to their gold badge date received.

Christianity Meta

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

-- Gold Java Badge Ranking in South Africa
-- This query retrieves all the gold java badge users and ranks them according to their gold badge date received.

SELECT u.DisplayName, max(b.Date) DateReceived
FROM Users u, Badges b
WHERE b.name='scala'
and u.Id=b.UserId
and u.Location like '%United Kingdom%'
and u.Reputation>2000
GROUP BY b.UserId, u.DisplayName
HAVING COUNT(*)>2
ORDER BY DateReceived DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results