SELECT DISTINCT user_name,

    CASE 

        WHEN user_editcount <= 4 THEN '1 to 4 edits'

        WHEN user_editcount >= 5 AND user_editcount <= 99 THEN '5 to 99 edits'

        WHEN user_editcount >= 100 AND user_editcount <= 999 THEN '100 to 999 edits'

        WHEN user_editcount >= 1000 THEN '1000+ edits'

    END AS edit_bucket

FROM user

LEFT JOIN user_groups

ON ug_user = user_id

WHERE user_editcount>0

AND (ug_group IS NULL

     OR ug_group NOT IN ('bot', 'flow-bot'))

GROUP BY edit_bucket