0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional mathematicians

; with counts_cte AS (
SELECT
  SUM(upvotes) AS countall,
  SUM(case when (reputation<=101) then upvotes else 0 end) AS countlow
  FROM Users
)

SELECT 
  countlow AS 'Upvotes from low rep users', 
  countall AS 'Total upvotes',
  ROUND((CAST(countlow AS decimal))*100.0/(CAST(countall AS decimal)),3) AS percentage
FROM counts_cte

fork query

edited may 9 20

created may 9 20 Martin20528