SELECT
  file.project,
  count(distinct details.system.release) as distinct_setups,
  count(*) as num_downloads
FROM `the-psf.pypi.downloads2017*`
WHERE LOWER(file.project) in ('cpickle','json', 'sqlite3','sqlite', 'marshal','math','os','pickle','platform','socket','stat','string','sys','tempfile')
and details.installer.name = 'pip'
GROUP BY file.project
ORDER BY num_downloads desc