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.

Q&A for professional and enthusiast programmers

-- Gold tag badges
-- ...

SELECT b.name, b.UserId, max(b.Date) DateReceived, u.DisplayName
FROM Users u, Badges b
WHERE u.Id=b.UserId
and ascii( name ) between 97 and 122
GROUP BY b.UserId, u.DisplayName, b.name
HAVING COUNT(*)>2
ORDER BY DateReceived

view current version

edited feb 3 12 martin clayton

created dec 14 11 The Elite Gentleman