0

Please login or register to vote for this query.

(click on this box to dismiss)

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, Badges.Date
FROM Users
INNER JOIN Badges ON Users.Id = Badges.Id
--WHERE  (Badges.date >'2015-12-31 00:00:00' AND Badges.date < '2017-01-01 00:00:00')
--AND Users.Location LIKE '%South Africa' AND Badges.Name = 'Enlightened'
--ORDER BY Users.Reputation DESC;

fork query

edited jul 12

created jul 12 anonymous