query.sql

SELECT
    ROUND(100 * SUM(CASE WHEN REGEXP_EXTRACT(details.installer.version, r"^([^\.]+)") IN ("18", "19") THEN 1 ELSE 0 END) / COUNT(*), 1) AS supports_518,
    COUNT(*) as downloads
FROM `the-psf.pypi.downloads*`
WHERE
  _TABLE_SUFFIX BETWEEN FORMAT_DATE("%E4Y%m%d", DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY))
                        AND FORMAT_DATE("%E4Y%m%d", CURRENT_DATE())
                AND details.installer.name = 'pip'
                AND file.project = 'cryptography'
LIMIT 100