Registration year of dewiki users

Fork of Distribution of registration time for users with 5+ edits (huwiki) by Tgr

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

See https://quarry.wmflabs.org/query/37312 for enwiki.
See https://quarry.wmflabs.org/query/37314 for 25+ edits.

SQL

use enwiki_p;

SELECT
	CONCAT(SUBSTR(user_registration, 1, 4)) AS registration_date,
    -- SUBSTR(user_registration, 1, 6) AS registration_date,
    count(*) AS new_users
FROM user
GROUP BY registration_date
ORDER BY registration_date
;

​x
 
use enwiki_p;​SELECT    CONCAT(SUBSTR(user_registration, 1, 4)) AS registration_date,    -- SUBSTR(user_registration, 1, 6) AS registration_date,    count(*) AS new_usersFROM userGROUP BY registration_dateORDER BY registration_date;

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...