Articles by size

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

use enwiki_p;
select
  page_len_category,
  count(*) as freq
from (
  select
    case
      when page_len < 1024 then 1
      when page_len >= 1024 and page_len < 2048 then 2
      when page_len >= 2048 and page_len < 3072 then 3
      when page_len >= 3072 and page_len < 4096 then 4
      when page_len >= 4096 and page_len < 5120 then 5
      when page_len >= 5120 and page_len < 6144 then 6
      when page_len >= 6144 and page_len < 7168 then 7
      when page_len >= 7168 and page_len < 8192 then 8
      when page_len >= 8192 and page_len < 9216 then 9
      when page_len >= 9216 and page_len < 10240 then 10
      when page_len >= 10240 and page_len < 11264 then 11
      when page_len >= 11264 and page_len < 12288 then 12
      when page_len >= 12288 and page_len < 13312 then 13
      when page_len >= 13312 and page_len < 14336 then 14
      when page_len >= 14336 and page_len < 15360 then 15
      when page_len >= 15360 and page_len < 16384 then 16
      when page_len >= 16384 and page_len < 17408 then 17
      when page_len >= 17408 and page_len < 18432 then 18
      when page_len >= 18432 and page_len < 19456 then 19
      when page_len >= 19456 and page_len < 20480 then 20
      when page_len >= 20480 and page_len < 21504 then 21
      when page_len >= 21504 and page_len < 22528 then 22
      when page_len >= 22528 and page_len < 23552 then 23
      when page_len >= 23552 and page_len < 24576 then 24
      when page_len >= 24576 and page_len < 25600 then 25
      when page_len >= 25600 and page_len < 26624 then 26
      when page_len >= 26624 and page_len < 27648 then 27
      when page_len >= 27648 and page_len < 28672 then 28
      when page_len >= 28672 and page_len < 29696 then 29
      when page_len >= 29696 and page_len < 30720 then 30
      when page_len >= 30720 and page_len < 31744 then 31
      when page_len >= 31744 and page_len < 32768 then 32
      when page_len >= 32768 and page_len < 33792 then 33
      when page_len >= 33792 and page_len < 34816 then 34
      when page_len >= 34816 and page_len < 35840 then 35
      when page_len >= 35840 and page_len < 36864 then 36
      when page_len >= 36864 and page_len < 37888 then 37
      when page_len >= 37888 and page_len < 38912 then 38
      when page_len >= 38912 and page_len < 39936 then 39
      when page_len >= 39936 and page_len < 40960 then 40
      when page_len >= 40960 and page_len < 41984 then 41
      when page_len >= 41984 and page_len < 43008 then 42
      when page_len >= 43008 and page_len < 44032 then 43
      when page_len >= 44032 and page_len < 45056 then 44
      when page_len >= 45056 and page_len < 46080 then 45
      when page_len >= 46080 and page_len < 47104 then 46
      when page_len >= 47104 and page_len < 48128 then 47
      when page_len >= 48128 and page_len < 49152 then 48
      when page_len >= 49152 and page_len < 50176 then 49
      when page_len >= 50176 and page_len < 51200 then 50
      when page_len >= 51200 and page_len < 52224 then 51
      when page_len >= 52224 and page_len < 53248 then 52
      when page_len >= 53248 and page_len < 54272 then 53
      when page_len >= 54272 and page_len < 55296 then 54
      when page_len >= 55296 and page_len < 56320 then 55
      when page_len >= 56320 and page_len < 57344 then 56
      when page_len >= 57344 and page_len < 58368 then 57
      when page_len >= 58368 and page_len < 59392 then 58
      when page_len >= 59392 and page_len < 60416 then 59
      when page_len >= 60416 and page_len < 61440 then 60
      when page_len >= 61440 and page_len < 62464 then 61
      when page_len >= 62464 and page_len < 63488 then 62
      when page_len >= 63488 and page_len < 64512 then 63
      when page_len >= 64512 and page_len < 65536 then 64
      when page_len >= 65536 and page_len < 66560 then 65
      when page_len >= 66560 and page_len < 67584 then 66
      when page_len >= 67584 and page_len < 68608 then 67
      when page_len >= 68608 and page_len < 69632 then 68
      when page_len >= 69632 and page_len < 70656 then 69
      when page_len >= 70656 and page_len < 71680 then 70
      when page_len >= 71680 and page_len < 72704 then 71
      when page_len >= 72704 and page_len < 73728 then 72
      when page_len >= 73728 and page_len < 74752 then 73
      when page_len >= 74752 and page_len < 75776 then 74
      when page_len >= 75776 and page_len < 76800 then 75
      when page_len >= 76800 and page_len < 77824 then 76
      when page_len >= 77824 and page_len < 78848 then 77
      when page_len >= 78848 and page_len < 79872 then 78
      when page_len >= 79872 and page_len < 80896 then 79
      when page_len >= 80896 and page_len < 81920 then 80
      when page_len >= 81920 and page_len < 82944 then 81
      when page_len >= 82944 and page_len < 83968 then 82
      when page_len >= 83968 and page_len < 84992 then 83
      when page_len >= 84992 and page_len < 86016 then 84
      when page_len >= 86016 and page_len < 87040 then 85
      when page_len >= 87040 and page_len < 88064 then 86
      when page_len >= 88064 and page_len < 89088 then 87
      when page_len >= 89088 and page_len < 90112 then 88
      when page_len >= 90112 and page_len < 91136 then 89
      when page_len >= 91136 and page_len < 92160 then 90
      when page_len >= 92160 and page_len < 93184 then 91
      when page_len >= 93184 and page_len < 94208 then 92
      when page_len >= 94208 and page_len < 95232 then 93
      when page_len >= 95232 and page_len < 96256 then 94
      when page_len >= 96256 and page_len < 97280 then 95
      when page_len >= 97280 and page_len < 98304 then 96
      when page_len >= 98304 and page_len < 99328 then 97
      when page_len >= 99328 and page_len < 100352 then 98
      when page_len >= 100352 and page_len < 101376 then 99
      when page_len >= 101376 and page_len < 102400 then 100
      else 101
    end as page_len_category
  from page
  where
    page_namespace = 0
) t
group by page_len_category
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...
