Proportion of edits during midnight hours (extensino of

SQL

use fawiki_p;
select
  actor_name,
  1.0 * sum(midnight) / count(*) as midnight_percent
from
(
  select
    actor_name,
    case
      when mid(rev_timestamp, 9, 2) in ('01', '02', '03', '04') then 1
      else 0
    end as midnight
  from revision
  join actor
    on rev_actor = actor_id
    and actor_user <> 0
  left join user_groups
    on ug_user = actor_user
    and ug_group = 'bot'
  where
    ug_user is null
    and actor_name <> 'پیام به کاربر جدید'
    and rev_timestamp > '20191001000000'
) m
group by actor_name
order by midnight_percent desc

SQL

Checking query status...