New answers tagged badges
2
The following query does that for you.
I've first created a Common Table Expression and named it Gold to give me a set with all the users that have a Gold Badge (The Class = 1 depicts that).
Then I select from the users table and do a LEFT OUTER JOIN with Gold, joining on the userid. The Users that don't have a Gold badge will not have a corresponding row in ...
0
I think partly it is how hard it is to preplan and do the work to get a badge. Most of my gold badges I have got due having asked good questions on the site a long time ago. I could not have planned any of these questions to give me a gold badge.
However if someone wishes to get the Generalist badge, it is easy to see how they could preplan a method of ...
Top 50 recent answers are included
