Dropouts in May

SQL

use fiwiki_p; 

select A.rev_user_text as Username, A.num_edits as Edits, coalesce(B.num_thanks, 0) as Thanks

from (select rev_user_text, count(rev_user_text) as num_edits
	from revision
    where
    	rev_timestamp < timestamp('2018-05-01') 
        and rev_timestamp >= timestamp('2018-04-01') 
		and rev_user_text in (select user_name from user)  
    group by rev_user_text
    order by count(rev_user_text)) as A
      
left join (select log_user_text, count(log_user_text) as num_thanks
      from logging_userindex
      where
      	 log_action = 'thank' and log_type='thanks'
         and log_timestamp < timestamp('2018-05-01')
      	 and log_timestamp >= timestamp('2018-04-01')
      group by log_user_text) as B
      
on A.rev_user_text = B.log_user_text

join (select user_name
	from user
    where
    	not user_name in (select rev_user_text 
                          from revision
                          where rev_timestamp < timestamp('2018-06-01') 
                          and rev_timestamp >= timestamp('2018-05-01'))
    ) as C

on A.rev_user_text=C.user_name;
/*
Find the number of users who edited in April but did not edit in May, ordered by how many edits they had that month, 
with info of how many thanks they got that month
*/
SQL

Checking query status...
