SQL
x
use dewiki_p;
#select count(case when A.num_edits >= 5 then 1 else null end)
select count(distinct rev_user)
from
(select rev_user, count(rev_user) as num_edits
from revision
where
(rev_user != 0
and rev_timestamp < timestamp('2018-07-01')
and rev_timestamp >= timestamp('2018-01-01'))
group by rev_user) as A
#order by count(rev_user)) as A;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.