select

    date_format(rev_timestamp, '%Y-%m-%d') as day,

    actor_name,

    count(*) as count

from revision

join actor

    on actor_id = rev_actor

where rev_timestamp like '2020%'

group by substring(rev_timestamp, 1, 8), actor_name

order by count(*) desc

limit 300;