Eligible by ukwiki voters

This query is marked as a draft This query has been published by Ilya.

SQL

USE ukwiki_p;

select rev_user_text, Gt20, Gt300 from 
(SELECT  rev_user_text, count(*) as Gt20 
from revision r1 
WHERE 
    		20161001 * 1000000 <= r1.rev_timestamp  AND 
    		r1.rev_timestamp < 20170401 * 1000000 
            group by r1.rev_user_text
            having Gt20 >= 20) t1,
(SELECT  rev_user_text, count(*) as Gt300 
from revision r2 
WHERE 
    		r2.rev_timestamp < 20170401 * 1000000 
            group by r2.rev_user_text
            having Gt300 >= 300) t2
            where t1.rev_user_text = t2.rev_user_text

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...