Skip to content

Instantly share code, notes, and snippets.

@josh-newman

josh-newman/go license.txt count.sql

Created June 6, 2020 00:18
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/4fc023b95568d7ac5fb9299a1897baf7 to your computer and use it in GitHub Desktop.
Save josh-newman/4fc023b95568d7ac5fb9299a1897baf7 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 `bigquery-public-data.github_repos.languages` using (repo_name)
where (array_length(language) > 0 and language[offset(0)].name = 'Go')
and (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