Part 1 - Quarry

SQL

select count(*)
from user
join actor_logging
  on actor_user = user_id
left join logging_userindex
  on log_actor = actor_id
  and log_type = 'newusers'
  and log_action in ('create', 'autocreate') -- creating main account
  and log_timestamp < '20200712000000' -- occured 3 or more months prior to nomination start date
join
(
  select
    actor_user,
    min(rev_timestamp) as first_timestamp
  from revision_userindex
  join actor_revision
    on rev_actor = actor_id
  group by actor_user
) first_edit
  on user_id = first_edit.actor_user
where
  (
    log_timestamp is not null
    or 
    first_timestamp < '20200712000000' -- occured 3 or more months prior to nomination start date
  )
order by user_name
SQL

Checking query status...
