0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select 
   count(Id) as Total,
   count(case when Reputation >= 10 then Id else NULL end) Min10,
   count(case when Reputation >= 50 then Id else NULL end) Min50,
   count(case when Reputation >= 100 then Id else NULL end) Min100,
   count(case when Reputation >= 200 then Id else NULL end) Min200,
   count(case when Reputation >= 500 then Id else NULL end) Min500,
   count(case when Reputation >= 1000 then Id else NULL end) Min1000,
   count(case when Reputation >= 2000 then Id else NULL end) Min2000,
   count(case when Reputation >= 5000 then Id else NULL end) Min5000,
   count(case when Reputation >= 10000 then Id else NULL end) Min10000,
   count(case when Reputation >= 20000 then Id else NULL end) Min20000,
   count(case when Reputation >= 50000 then Id else NULL end) Min50000,
   count(case when Reputation >= 100000 then Id else NULL end) Min100000,
   count(case when Reputation >= 200000 then Id else NULL end) Min200000
from Users

view current version

edited jul 1 13

created jul 1 13 Tomas