Untitled query #48660

This query is marked as a draft This query has been published by JHernandez (WMF).

SQL

SELECT tmp.country_code, COUNT(DISTINCT CONCAT(tmp.wiki_db, tmp.user_fingerprint_or_id)) AS editors
FROM
(SELECT wiki_db, country_code, user_fingerprint_or_id, SUM(edit_count) AS edits
FROM wmf.editors_daily
WHERE month = '{SNAPSHOT}'  AND country_code != '--'
GROUP BY wiki_db, country_code, user_fingerprint_or_id
) AS tmp
WHERE tmp.edits>=5
GROUP BY tmp.country_code

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