big_query.sql

SELECT
  COUNT(*) AS num_downloads,
  100 * COUNT(*) / SUM(COUNT(*)) OVER () AS percent_of_total,
  'installer=' || coalesce(details.installer.name, '?') || 
  ' system=' || coalesce(details.system.name  || details.system.release, '?') || 
  ' distro=' || coalesce(details.distro.name || details.distro.version, '?') as setup
FROM `bigquery-public-data.pypi.file_downloads`
WHERE
  file.project = '...'
  AND DATE_TRUNC(DATE(timestamp), MONTH) >= DATE_TRUNC(current_date(), month)
GROUP BY `setup`
ORDER BY `num_downloads` DESC