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?
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
And here are the results I got back:
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!