<jupyter_start><jupyter_text>Question1 - Which countries use a unit other than ppm to measure any type of pollution?<jupyter_code>import bq_helper

data = bq_helper.BigQueryHelper(active_project='bigquery-public-data',
                                dataset_name='openaq')



data.list_tables()
data.head("global_air_quality")
query1 = """ SELECT DISTINCT country, unit
            FROM `bigquery-public-data.openaq.global_air_quality`
            WHERE LOWER(unit) != 'ppm'"""
data.estimate_query_size(query1)
q1_data = data.query_to_pandas_safe(query1)
q1_data<jupyter_output><empty_output><jupyter_text>Question 2 - Which pollutants have a value of exactly 0?<jupyter_code>query2 = """SELECT location, city,  pollutant, value
            FROM `bigquery-public-data.openaq.global_air_quality`
            WHERE value = 0"""
data.estimate_query_size(query2)
data2 = data.query_to_pandas_safe(query2)
data2<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.10032017075773746, 'fraction_numerical': 0.014941302027748132, 'mean_word_length': 4.453488372093023, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '2', 'dir': 'jupyter-structured-clean-dedup', 'id': '401496', 'license': 'MIT', 'n_tokens_mistral': 327, 'n_tokens_neox': 311, 'n_words': 58, 'path': 'sql_bigquery/sql_day1.ipynb', 'repo_name': 'mathxyz/stock2', 'size': '937'}