My Northern Achiever Challenge Wikidata edit count

SQL

select actor_name, count(*) as edits
from wikidatawiki_p.revision_userindex r
join wikidatawiki_p.actor a on r.rev_actor = a.actor_id
join wikidatawiki_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",
"Xerosky",
"Musahfm",
"IBS-Gh",
"Dhee jah",
"Kum1989",
"Karimba Asani",
"Ernesztina",
"Ernesztina",
"Lukmanbamba"
)
and rev_timestamp between 20200901000000 and 20200915235959 # from October 1, 2020 00:00:00 UTC to October 31, 2020 00:00:00 UTC
and page_namespace in (0, 118) # Main and Draft
group by rev_actor
SQL

Checking query status...
