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 people interested in statistics, machine learning, data analysis, data mining, and data visualization

-- 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 4, 1

fork query

edited feb 3 12 martin clayton

created dec 14 11 The Elite Gentleman