I was actually interested in looking at which MIME types were used for
<script src> requests, but I could not find anything in the data to get exactly that (short of scraping URLs from request bodies and then looking them up in the requests table, maybe?)... But
Accept: */* is used for such requests, but I think also some other requests (stylesheets? fonts?
SELECT mime_type, COUNT(*) AS num, RATIO_TO_REPORT(num) OVER() AS ratio
SELECT req_headers, REGEXP_EXTRACT(LOWER(res_headers), r'"name":"content-type","value":"\s*([^";]+)') AS mime_type
JSON_EXTRACT(payload, '$.request.headers') AS req_headers,
JSON_EXTRACT(payload, '$.response.headers') AS res_headers
WHERE req_headers CONTAINS '"name":"Accept","value":"*/*"'
GROUP BY mime_type
ORDER BY num DESC