use bnwiki_p;

​

select

    rev_actor,

    actor_name,

    count(rev_id) as edit_count,

    substr(user_registration, 1, 8) as registration_date

from

    revision,

    actor,

    user

where

    actor_user = user_id and

    user_registration between 20190700000000 and 20191100000000 and

    rev_timestamp > 20190700000000 and

    rev_actor = actor_id

group by

    rev_actor

having

    count(rev_id) between 100 and 1000

order by

    user_registration desc;