daily pastebin goal
69%
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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top