const sqlFormatter = require("sql-formatter")
const query = `WITH
go_repos AS (
SELECT
repo_name
FROM
\`bigquery-public-data.github_repos.languages\`,
UNNEST(LANGUAGE) AS
LANGUAGE
WHERE
LANGUAGE.name = "Go" )
SELECT
(
SELECT
COUNT(*) AS count
FROM
go_repos
JOIN (
SELECT
repo_name
FROM
\`bigquery-public-data.github_repos.files\`
WHERE
path = "go.sum"
GROUP BY
repo_name ) AS go_modules
ON
go_repos.repo_name = go_modules.repo_name) AS go_dot_sum,
(
SELECT
COUNT(*) AS count
FROM
go_repos
JOIN (
SELECT
repo_name
FROM
\`bigquery-public-data.github_repos.files\`
WHERE
path = "go.mod"
GROUP BY
repo_name ) AS go_modules
ON
go_repos.repo_name = go_modules.repo_name) AS go_dot_mod`
console.log(sqlFormatter.format(query))
no comments
sign in to comment