dropout histogram 2.0

SQL

use hiwiki_p;

select A.rev_user
from 
	
    (select rev_user, rev_timestamp
    	from revision
        where
     		#made an edit in November 2016
     		rev_user != 0
     		and
    		(rev_timestamp < timestamp('2016-12-01') and rev_timestamp >= timestamp('2016-11-01'))
    	group by rev_user) as A
    
    #join
    #(select user_name
    #from user) as B
    #on A.rev_user_text = B.user_name
        
    left join
    (select rev_user, rev_timestamp
    	from revision
        where
     		#has not made an edit in some range of time since then
    		(rev_timestamp < timestamp('2017-11-01') and rev_timestamp >= timestamp('2016-12-01'))
    	group by rev_user) as C
    on A.rev_user = C.rev_user
    
    where (C.rev_user is null);
SQL

Checking query status...
