Quartiles of Reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Homebrewing

Q&A for dedicated home brewers and serious enthusiasts

-- Enter Query Title
-- Enter Query Description

with tmp as (
      select reputation, qt=NTILE(10) over (order by reputation), 
      rn=ROW_NUMBER() over (order by reputation)
      from users where reputation > 1)
select count(rn) from tmp group by qt

Enter Parameters

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