SELECT
details.installer.name,
details.installer.version,
COUNT(*) as total_downloads
FROM
TABLE_DATE_RANGE(
[the-psf:pypi.downloads],
TIMESTAMP("20160114"),
CURRENT_TIMESTAMP()
)
WHERE
REGEXP_MATCH(details.python, r"^3.6")
GROUP BY
details.installer.name,
details.installer.version
ORDER BY
total_downloads DESC
LIMIT 100
| Row |
details_installer_name |
details_installer_version |
total_downloads |
| 1 |
pip |
9.0.1 |
262450316 |
| 2 |
setuptools |
28.8.0 |
3499929 |
| 3 |
setuptools |
36.0.1 |
1606610 |
| 4 |
pip |
8.1.2 |
1470281 |
| 5 |
setuptools |
27.2.0 |
848139 |
| 6 |
setuptools |
35.0.2 |
825094 |
| 7 |
pip |
8.1.1 |
757826 |
| 8 |
setuptools |
36.2.0 |
734394 |
| 9 |
setuptools |
36.5.0 |
717401 |
