Quartiles of Reputation


Please login or register to vote for this query.

(click on this box to dismiss)


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), max(reputation) from tmp group by qt

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results