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 int

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

SELECT tmp.editors, (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