use bnwiki_p;

​

select

    rev_actor,

    actor_name,

    count(rev_id) as edit_count

from

    revision,

    actor

where

    rev_timestamp > 20190300000000 and

    rev_actor = actor_id

group by

    rev_actor

having

    count(rev_id) between 1000 and 5000

order by

    edit_count desc;