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)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

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 LastAccessDate >= getdate() - 14
) as tmp;

Enter Parameters

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