User created

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

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

-- select id from PostTypes where name = 'Question';

select u.displayname, u.id, count(b.name) OVER (PARTITION BY 
b.name) from USERS u INNER JOIN BADGES b on u.id = b.userId
where 
u.reputation in (select max(reputation) from users where location='South Africa')


;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results