This query is marked as a draft This query has been published by Swagoel.

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.

Checking query status...