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