SELECT
  details.distro.name as distro_name,
  details.distro.version as distro_version,
  details.distro.libc.lib as libc_name,
  details.distro.libc.version as libc_version,
  COUNT(*) as download_count,
FROM `bigquery-public-data.pypi.file_downloads`
WHERE timestamp BETWEEN TIMESTAMP_ADD(CURRENT_TIMESTAMP(), INTERVAL -6 DAY) AND TIMESTAMP_ADD(CURRENT_TIMESTAMP(), INTERVAL -1 DAY)
  AND details.installer.name = "pip"
  AND details.system.name = "Linux"
  AND file.filename LIKE "%musllinux%"
  AND (details.distro.libc.lib IS NULL OR details.distro.libc.lib != "glibc")
GROUP BY
  distro_name, distro_version, libc_name, libc_version
ORDER BY
  download_count DESC
LIMIT 100