use eswiki_p;

-- select * from actor where actor_name = 'SeroBOT'; -- 21

select substr(rev_timestamp, 1, 6) as date, count(1) counted 

from revision_userindex

inner join page on rev_page = page_id

where rev_actor = 21 

    and rev_timestamp between '20190101000000' and '20221231235959'

    -- and page_namespace = 0

group by 1

-- having counted > 7

​