SHARE
TWEET

Untitled

a guest May 19th, 2017 42 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.   file.project,
  3.   count(distinct details.system.release) as distinct_setups,
  4.   count(*) as num_downloads
  5. FROM `the-psf.pypi.downloads2017*`
  6. WHERE LOWER(file.project) in ('cpickle','json', 'sqlite3','sqlite', 'marshal','math','os','pickle','platform','socket','stat','string','sys','tempfile')
  7. and details.installer.name = 'pip'
  8. GROUP BY file.project
  9. ORDER BY num_downloads desc
RAW Paste Data
Top