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.

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

-- 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 b.UserId, max(b.Date) DateReceived, u.DisplayName
FROM Users u, Badges b
WHERE b.name='java'
and u.Id=b.UserId
and u.Location like '%Serbia%'
GROUP BY b.UserId, u.DisplayName
HAVING COUNT(*)>2
ORDER BY DateReceived

Enter Parameters

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