<Kaggle-Course>

캐글​ advanced_sql/03-nested-and-repeated-data

9566 2023. 3. 15. 19:46
728x90
pop_lang_query = """
                 SELECT language.name AS language_name, COUNT(*) AS num_repos
                 FROM `bigquery-public-data.github_repos.languages`,
                     UNNEST(language) AS language
                 GROUP BY language_name
                 ORDER BY num_repos DESC
                 """​
all_langs_query = """
                  SELECT language.name AS name, language.bytes AS bytes
                  FROM `bigquery-public-data.github_repos.languages`,
                      UNNEST(language) AS language
                  WHERE repo_name = 'polyrabbit/polyglot'
                  ORDER BY bytes DESC
                  """
max_commits_query = """
                    SELECT committer.name AS committer_name, COUNT(1) AS num_commits
                    FROM `bigquery-public-data.github_repos.sample_commits`
                    WHERE EXTRACT(YEAR FROM committer.date) = 2016
                    GROUP BY committer_name
                    ORDER BY num_commits DESC
                    """
728x90