       COUNT(0) / SUM(COUNT(0)) OVER (PARTITION BY client) AS pct_crawl
            FROM
              `httparchive.all.requests`,
            UNNEST (request_headers) AS req_headers
            WHERE
              date = '2024-06-01' AND
              is_root_page AND
              is_main_document AND
              LOWER(req_headers.name) = "user-agent"
            GROUP BY
              client,
              req_headers.value
            QUALIFY
              COUNT(0) = MAX(COUNT(0)) OVER (PARTITION BY c