This query retrieves all the gold java badge users and ranks them according to their gold badge date received.
Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
-- 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 '%Israel%' GROUP BY b.UserId, u.DisplayName HAVING COUNT(*)>2 ORDER BY DateReceived