Untitled query #27100

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

SQL

USE euwiki_p;
SELECT IF(page_len < 1000, "5k",
          IF(page_len BETWEEN 1001 AND 10000, "1-10k", 
          IF(page_len BETWEEN 10001 AND 20000, "10-20k",
          IF(page_len BETWEEN 20001 AND 30000, "20-30k",
          IF(page_len BETWEEN 30001 AND 50000, "30-50k", 
          IF(page_len BETWEEN 50001 AND 100000, "50-100k", "100k-")))) AS size_range, COUNT(*) FROM page WHERE page_namespace = 0 GROUP BY 1;

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