```sql
SELECT
  REGEXP_EXTRACT(details.python, r"^([^\.]+\.[^\.]+)") as python_version,
  details.installer.name,
  details.installer.version,
  COUNT(*) as total_downloads
FROM
  TABLE_DATE_RANGE(
    [the-psf:pypi.downloads],
    TIMESTAMP("20160114"),
    CURRENT_TIMESTAMP()
  )
GROUP BY
  python_version,
  details.installer.name,
  details.installer.version
ORDER BY
  total_downloads DESC
LIMIT 100
```

|Row|python_version|details_installer_name|details_installer_version |total_downloads |
|-|-|-|-|-|
|1|2.7|pip|9.0.1|2329351194	|
|2|2.7|pip|6.0.8|1026930256	|
|3|2.7|pip|8.1.2|827186887	|
|4|2.7|pip|1.5.4|749604308	|
|5|null|bandersnatch|1.11|714791614	|
|6|2.7|null|null|638936352	|
|7|2.7|pip|6.1.1|436756002	|
|8|3.5|pip|9.0.1|321444466	|
|9|2.7|pip|7.1.2|284777575	|
|10|3.6|pip|9.0.1|262371972	|
|11|2.7|pip|8.1.1|261798294	|