Yli 100 muokkausta kuukaudessa tehneet suomenkielisessä Wikipediassa

SQL

SELECT
	d,
    sum(1) as total,
    sum(c>99) 100plus,
    sum(c>199) 200plus,
    sum(c>499) 500plus,
    sum(c>999) 1000plus
FROM (
  SELECT 
      floor(rev_timestamp/100000000) AS d, 
      rev_user, SUM(1) AS c 
  FROM 
      revision_compat 
      LEFT JOIN user_groups ON ug_user=rev_user AND ug_group='bot' 
      LEFT JOIN user_former_groups ON ufg_user=rev_user AND ufg_group='bot'  
  WHERE 
      ug_user IS NULL 
      AND ufg_user IS NULL 
      AND rev_user_text NOT LIKE "%bot%" 
      AND rev_user_text NOT LIKE "%BOT%"
      AND rev_user_text NOT LIKE "%Bot%" 
      AND rev_user !=0 
      AND rev_id > 20202600 
  GROUP BY d, rev_user
) as t
GROUP BY d

SQL

Checking query status...