# Summing bytes in interquartile range of page size

**URL:** <https://discuss.httparchive.org/t/summing-bytes-in-interquartile-range-of-page-size/1952>\
**Category:** Analysis\
**Created:** [June 3, 2020, 11:40pm UTC](https://discuss.httparchive.org/t/summing-bytes-in-interquartile-range-of-page-size/1952 "2020-06-03T23:40:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kevingal](https://avatars.discourse-cdn.com/v4/letter/k/5f9b8f/32.png) [@kevingal](https://discuss.httparchive.org/u/kevingal)\
**Post date:** [June 3, 2020, 11:40pm UTC](https://discuss.httparchive.org/t/summing-bytes-in-interquartile-range-of-page-size/1952/1 "2020-06-03T23:40:03Z")

</div>

I want to find the sum of HTML bytes, CSS bytes, etc., for all of the webpages in the interquartile range of page size. Here’s the query I’ve tried, does it / the results look okay?

```sql
SELECT
  SUM(bytesHtml) as html,
  SUM(bytesJS) as js,
  SUM(bytesCSS) as css,
  SUM(bytesImg) as img,
  SUM(bytesFont) as font,
  SUM(bytesVideo) as video,
  COUNT(*) as count
FROM
  `httparchive.summary_pages.2020_04_01_desktop`
WHERE
  bytesTotal >= 1020416 AND bytesTotal <= 4007731

```

The bounds on bytesTotal are the values of p25 and p75, plucked from here: [https://httparchive.org/reports/page-weight#bytesTotal](https://httparchive.org/reports/page-weight#bytesTotal)

And here are the results I got back:

```sql
html 117444183625
js 1492513128682
css 283180779936
img 2814808632228
font 363177891001
video 70743962271
count 2330112

```

Just want to double-check my work to make sure I’m not doing something stupid, thanks!