SQL
x
USE dewiki_p;
SELECT
SUBSTR(rev_timestamp, 1, 8) AS bucket,
COUNT(rev_id) AS cnt
FROM
revision
WHERE
rev_id>170000000
AND rev_timestamp>=20190101000000
GROUP BY
bucket
ORDER BY
bucket ASC
;
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.