1

Please login or register to vote for this query.

(click on this box to dismiss)

Badges people should not have

Q&A for professional and enthusiast programmers

select UserId as [User Link], Name, Count(*) from Badges
where Name in ('Teacher',
'Student',
'Editor',
'Cleanup',
'Organizer',
'Supporter',
'Critic',
'Citizen Patrol',
'Autobiographer',
'Scholar',
'Taxonomist',
'Strunk & White',
'Self-Learner',
'Generalist',
'Hacker',
'Beta',
'Commentator',
'Civic Duty',
'Disciplined',
'Peer Pressure',
'Tumbleweed',
'Enthusiast',
'Fanatic',
'Pundit',
'Mortarboard',
'Epic',
'Legendary',
'Electorate')
group by UserId, Name
having count(*) > 1

fork query

created jul 5 10 sam.saffron