Revisions by month for editors who joined FA WP in 2015

SQL

use fawiki_p;
select rev.rev_user, left(rev.rev_timestamp, 6) as yearmonth, count(rev.rev_id) as edits
from revision rev join
(
  select user_id from
  (
    select user_id, min(rev_timestamp) as first_edit
    from user
    join revision
    on rev_user = user_id
    group by rev_user
  ) f
  left join user_groups
  on user_id = ug_user
  and ug_group = 'bot'
  where first_edit > '20150101000000'
  and first_edit < '20160101000000'
  and ug_group is null
) u2015
on rev.rev_user = u2015.user_id
group by rev.rev_user, left(rev.rev_timestamp, 6)
order by 1, 2

SQL

Checking query status...