Untitled query #83214

SQL

WITH useredit as (
select distinct(user_name),
  user_editcount ,
  case 
  	when user_editcount = 0 then 'No Edits'
  	when user_editcount >0 and user_editcount <6 then '1-5'
  	when user_editcount >5 and user_editcount < 100 then '6-99'
  	when user_editcount > 99 and user_editcount < 1000 then '100-999'
  	when user_editcount > 999 and user_editcount < 5000 then '999-4999'
  	else '>5000'
  	end user_editrange
  from user join 
  actor on actor.actor_user=user.user_id 
  join revision ON 
  actor.actor_id=revision.rev_actor
)

select user_editrange,count(user_editrange) from useredit group by user_editcount
SQL

Checking query status...
