0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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

SELECT * FROM Badges WHERE Name = 'Enlightened' AND "Date" LIKE '2016%';




--SELECT COUNT(Users.Id) FROM Users
--INNER JOIN Badges ON Users.Id = Badges.Id;

--SELECT 

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

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

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

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

fork query

edited jul 12 20

created jul 12 20 anonymous