0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

/* select avg(reputation) median from (
  select reputation,
  rasc = row_number() over(order by reputation),
  rdesc = row_number() over(order by reputation desc)
  from users where reputation > 1
) b where rasc between rdesc - 1 and rdesc + 1 */

select count(*) as c from users -- where reputation > 1 order by reputation desc

fork query

edited aug 13

created aug 13 cherryblossom32273