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 professionals and students of engineering

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

SELECT
  u.*
FROM
  Users u, Badges b
WHERE
  b.name = 'java'
  and u.Id = b.UserId
ORDER BY u.reputation

fork query

edited sep 8 12 anonymous

created dec 14 11 The Elite Gentleman