728x90
zero_pollution_query = """SELECT *
FROM `bigquery-public-data.openaq.global_air_quality`
WHERE value = 0"""first_query = """SELECT DISTINCT country
FROM `bigquery-public-data.openaq.global_air_quality`
WHERE unit = "ppm" """728x90
'<Kaggle-Course>' 카테고리의 다른 글
| 캐글 advanced_sql/03-nested-and-repeated-data (0) | 2023.03.15 |
|---|---|
| 캐글 advanced_sql/01-joins-and-unions (0) | 2023.03.15 |
| 캐글 intro_to_sql/03-group-by-having-count (0) | 2023.03.15 |
| 캐글 intro_to_sql/05-as-with (0) | 2023.03.15 |
| 캐글 intro_to_sql/04-order-by (0) | 2023.03.15 |