Count of Users who can Downvote

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

SELECT
COUNT(u.Id) AS 'Total Users',
COUNT(CASE WHEN u.Reputation >= 125 THEN 1 ELSE NULL END) AS 'Total Can DV',
CAST(
ROUND(
  COUNT(
    CASE WHEN u.Reputation >= 125 THEN 1 ELSE NULL END
    ) / CAST(COUNT(u.Id) AS Float) * 100
, 4)
AS nvarchar) + '%' AS '% Can DV'
FROM Users u

-- 125 pulled from https://stackoverflow.com/help/privileges/vote-down

Enter Parameters

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