test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics

Q&A for professional robotic engineers, hobbyists, researchers and students

SELECT COUNT(b.id) 'Badge Count',DisplayName,b.name 
from users u 
join badges b on u.id = b.userId
where reputation = (SELECT MAX(reputation) FROM users WHERE location ='South Africa')
and b.name ='Enlightened'
and YEAR(b.date) = '2016'
group by DisplayName,b.name

Enter Parameters

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