SELECT top 10 Users.Reputation, Users.DisplayName, User...

0

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;
--What is the name of the most reputable "South Africa" user and how many "Enlightened" badges did
--they receive in 2016?

SELECT top 10 Users.Reputation, Users.DisplayName, Users.Location, Badges.Name, Badges.Date
FROM Users
INNER JOIN Badges ON Users.Id = Badges.Id
WHERE Users.Location LIKE '%South Africa' AND Badges.Name = 'Enlightened'
  AND Badges.[Date] like '2016-0%'
--(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;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results