728x90
nested-and-repeated
-
캐글 advanced_sql/03-nested-and-repeated-data<Kaggle-Course> 2023. 3. 15. 19:46
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 = 'polyrab..