SELECT top 5 DisplayName, Location FROM Users INN...


Please login or register to vote for this query.

(click on this box to dismiss)

Computer Graphics

Q&A for computer graphics researchers and programmers

-- [Enter Query Title]
--select count(id) from posts;

--SELECT * FROM Badges

--What is the name of the most reputable "South Africa" user and
--how many "Enlightened" badges did they receive in 2016?

--INNER JOIN Badges ON Users.Id = Badges.Id;


--SELECT * From Users where Reputation = '1194368'

--SELECT MAX(Reputation), DisplayName AS Reputation FROM Users;

SELECT top 5 DisplayName, Location
FROM Users
INNER JOIN Badges ON Users.Id = Badges.Id
WHERE Location LIKE '%South Africa'
ORDER BY Reputation DESC;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results