SELECT * FROM Badges WHERE Date like '2015' AND Name = '...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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

SELECT * FROM Badges WHERE Date like '2015' AND Name = 'Enlightened';




--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;

Enter Parameters

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