Crossref edityear-regyear 1

SQL

select 
	edit_year, 
    sum(c) as cc, 
	sum(reg_year IS NULL) as yUnknown,     
    sum(reg_year=2002) as y2002, 
    sum(reg_year=2003) as y2003, 
    sum(reg_year=2004) as y2004,     
	sum(reg_year=2005) as y2005,         
	sum(reg_year=2006) as y2006,         
	sum(reg_year=2007) as y2007,             
	sum(reg_year=2008) as y2008,                 
	sum(reg_year=2009) as y2009,                     
	sum(reg_year=2010) as y2010,                     
	sum(reg_year=2011) as y2011,                     
    sum(reg_year=2012) as y2012, 
    sum(reg_year=2013) as y2013, 
    sum(reg_year=2014) as y2014,     
	sum(reg_year=2015) as y2015,         
	sum(reg_year=2016) as y2016,         
	sum(reg_year=2017) as y2017,             
	sum(reg_year=2018) as y2018,                 
	sum(reg_year=2019) as y2019,                     
	sum(reg_year=2020) as y2020,                     
	sum(reg_year=2021) as y2021                     
    
from (
  select 
  	floor(rev_timestamp/10000000000) as edit_year, 
  	sum(1) as c, 
  	floor(user_registration/10000000000) as reg_year 
  from 
  	revision_compat, 
  	user 
  where 
  	rev_user>0 
  	and user_id=rev_user 
  group by edit_year, user_id
) as tt 
group by edit_year
SQL

Checking query status...
