My Northern Achiever Challenge Wikipedia edit count in time frame

SQL

select actor_name, count(*) as edits
from enwiki_p.revision_userindex r
join enwiki_p.actor a on r.rev_actor = a.actor_id
join enwiki_p.page p on r.rev_page = p.page_id
where actor_name in (
"Masssly",
"Abubakari Khadijah",
"Shahadusadik",
"Dnshitobu",
"SalimQuo",
"Alhassan Mohammed Awal",
"Din-nani1",
"Zak Raha",
"Hidrash",
"Achiri Bitamsimli",
"Alhaj Darajaati",
"Yabeha wiki",
"Hasslaebetch",
"Alhassan Peter",
"Musahfm",
"IBS-Gh",
"Dhee jah",
"Kum1989",
"Karimba Asani",
"Ernesztina",
"Alidu Shafawu",
"Lukmanbamba"
)
and rev_timestamp between 20201001000000 and 20201031235959 # from October 1, 2020 00:00:00 UTC to October 31, 2020 23:59:59 UTC
and page_namespace in (0, 118) # Main and Draft
group by rev_actor

SQL

Checking query status...