Gold SwingBadge Ranking in South Africa

0

Please login or register to vote for this query.

(click on this box to dismiss)

Biology Meta

Q&A about the site for biology researchers, academics, and students

-- 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='swing'
and u.Id=b.UserId
and u.Location like '%South Africa%'
GROUP BY b.UserId, u.DisplayName
HAVING COUNT(*)>2
ORDER BY DateReceived

Enter Parameters

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