Number of users who can edit questions and answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

DECLARE @numUsers float

SELECT @numUsers = COUNT(*) FROM Users
-------------------------------------

SELECT tmp.editors as [can edit], 
  @numUsers as [total users] ,tmp.editors/@numUsers as [% of total users]
FROM (
  SELECT 
      COUNT(*) as editors    
  FROM
      Users
      WHERE Reputation >= 2000
) as tmp;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results