New answers tagged

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