Articles by size

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

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