dropout histogram 3.0

SQL

use hiwiki_p;

select A.rev_user as ID, A.num_edits as Edits, B.user_registration as Registration
from 
	
    (select rev_user, rev_timestamp, count(rev_user) as num_edits
    	from revision
        where
     		#made an edit in November 2016
     		rev_user != 0
     		and
    		(rev_timestamp < timestamp('2017-02-01') and rev_timestamp >= timestamp('2017-01-01'))
    	group by rev_user) as A
    
    join
    (select user_id, user_registration
    	from user) as B
    on A.rev_user = B.user_id
        
    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('2018-02-01') and rev_timestamp >= timestamp('2017-02-01'))
    	group by rev_user) as C
    on A.rev_user = C.rev_user
    
    where (C.rev_user is null)
    order by user_registration;
SQL

Checking query status...
