SQL
x
use kowiki_p;
select count(distinct A.rev_user_text)
from
(select rev_user_text, rev_timestamp
from revision
where
#made an edit in November 2016
(rev_timestamp < timestamp('2016-12-01') and rev_timestamp >= timestamp('2016-11-01'))
group by rev_user_text) as A
join
(select user_name
from user) as B
on A.rev_user_text = B.user_name
left join
(select rev_user_text, rev_timestamp
from revision
where
#has not made an edit in some range of time since then
(rev_timestamp < timestamp('2017-08-01') and rev_timestamp >= timestamp('2016-12-01'))
group by rev_user_text) as C
on A.rev_user_text = C.rev_user_text
where (C.rev_user_text is null)
limit 4000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.