Thanks senders vs receivers

SQL

use nlwiki_p; 

select A.user_name as Username, A.num_edits as Edits, B.num_thanks as Thanks

from (select user_name, user_editcount as num_edits
	from user) as A
      
join (select log_title, count(log_title) 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-06-01')
      group by log_title
      limit 5000) as B
      
on A.user_name = B.log_title

order by A.num_edits;

/*
Take every person who has sent (also use for received) a thank in the last month and find how many thanks they sent (or received)
as well as how many edits they have made (ever, as opposed to the edits for the month), 
and order from smallest to largest number of edits
*/
SQL

Checking query status...
