Skip to content

Instantly share code, notes, and snippets.

@josh-newman

josh-newman/go license.txt count.sql

Created June 6, 2020 00:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save josh-newman/e2e41cdb5ed7df26b1543db2a1699a06 to your computer and use it in GitHub Desktop.
Save josh-newman/e2e41cdb5ed7df26b1543db2a1699a06 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
go license.txt count.sql
select
path
,count(1)
from `bigquery-public-data.github_repos.files`
join (
select distinct repo_name
from `bigquery-public-data.github_repos.languages`
cross join unnest(language)
where name = 'Go'
) using (repo_name)
where (path = 'LICENSE.txt' or path = 'LICENSE')
group by 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment