select Date from Badges; SELECT top 5 Users.DisplayName,...


Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

--SELECT * FROM Badges 
--WHERE Name = 'Enlightened' AND (date >'2015-12-31 00:00:00' AND date < '2017-01-01 00:00:00');

select Date from Badges;
SELECT top 5 Users.DisplayName, Users.Location, Badges.Name
FROM Users
INNER JOIN Badges ON Users.Id = Badges.Id
WHERE  ( >'2015-12-31 00:00:00' AND < '2017-01-01 00:00:00')
AND Users.Location LIKE '%South Africa' AND Badges.Name = 'Enlightened'
ORDER BY Users.Reputation DESC;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results