02# SQL for Data Science

Big Query: Select, From & Where

SELECT…FROM

WHERE…

Air Control Big Data

OpenAQ

02#SQL-Data-Science

Air Quality Control

Exercise: Select, From & Where

Diference Tables vs DataSet

High air quality

Which pollution levels were reported to be exactly 0?

• Set zero_pollution_query to select all columns of the rows where the value column is 0.
• Set zero_pollution_results to a pandas DataFrame containing the query results.