Skip to content

Instantly share code, notes, and snippets.

@monorkin

monorkin/repository-license-count.sql

Created August 26, 2018 15:05
Show Gist options
  • Save monorkin/258cc4daeaf4dc130cbcf7c16a70f15e to your computer and use it in GitHub Desktop.
Save monorkin/258cc4daeaf4dc130cbcf7c16a70f15e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
repository-license-count.sql
SELECT licenses.license AS license, COUNT(licenses.repo_name) AS count
FROM [bigquery-public-data:github_repos.licenses] AS licenses
JOIN [bigquery-public-data:github_repos.languages] AS languages ON licenses.repo_name = languages.repo_name
WHERE languages.language.name = '<language name>'
GROUP BY license
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment