stestagg · May 19, 2017 19:45
diff --git a/pypi.sql b/pypi.sql
 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
	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