use awawiki_p;

​

select

    rev_actor,

    actor_name,

    count(rev_id) as edit_count

from

    revision,

    actor

where

    rev_timestamp > 20200600000000 and

    rev_actor = actor_id 

group by

    rev_actor

having

    count(rev_id) between 5 and 10000

order by

    edit_count desc;