/*select TOP 1 u.DisplayName, u.Reputation, count(b.Id) a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature Meta

Q&A about the site for scholars and enthusiasts of literature

/*select TOP 1 u.DisplayName, u.Reputation, count(b.Id) as BadgeCount from Users u
join Badges b ON u.AccountId = b.UserId
 where Location like '%South Africa'
 and year(b.Date) = 2016
 and b.name = 'Enlightened'
 group by u.DisplayName, u.Reputation
 order by u.Reputation desc*/
 
 /*select TOP 1 Reputation, DisplayName, AccountId into #A1
 from Users where AccountId in 
 (select UserId from Badges where year(date) = 2016 and Name = 'Enlightened')
 and Location like '%South Africa'
 order by Reputation Desc
 select a.Reputation, a.DisplayName, count(b.Id) from #A1 a
 join Badges b
 ON a.AccountId = b.UserId
 and year(b.date) = 2016
 and b.Name = 'Enlightened'
 group by a.DisplayName, a.Reputation*/


/*select TOP 1 u.DisplayName, u.Reputation, count(b.Id) as BadgeCount from Users u
join Badges b ON u.Id = b.UserId
 where Location like '%South Africa'
 and year(b.Date) = 2016
 and b.name = 'Enlightened'
 group by u.DisplayName, u.Reputation
 order by u.Reputation desc*/
 
 select Max(Reputation), DisplayName 
 from Users where Location like '%South Africa'
 group by DisplayName

Enter Parameters

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