SQL
AخA
USE dewiki_p;
SELECT COUNT(user_registration)
FROM user
INNER JOIN (SELECT
rev_user_text AS edit_username,
COUNT(rev_id) AS edits_month
FROM revision_compat
WHERE rev_timestamp > "20200801000000"
AND rev_timestamp < "20201101000000"
GROUP BY edit_username
) AS last_edits
ON user_name = edit_username
WHERE user_registration > 20200801000000
AND user_registration < 20200901000000
AND edits_month >= "1"
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.