02# SQL for Data Science

Big Query: Select, From & Where

SELECT…FROM

WHERE…

Air Control Big Data

[OpenAQ
OpenAQ is a community of scientists, software developers, and lovers of open environmental dataopenaq.org](https://openaq.org/#/ "https://openaq.org/#/")

[02#SQL-Data-Science
Explore and run machine learning code with Kaggle Notebooks | Using data from No attached data sourceswww.kaggle.com](https://www.kaggle.com/viannaandresouza/02-sql-data-science "https://www.kaggle.com/viannaandresouza/02-sql-data-science")

Air Quality Control

[Exercise: Select, From & Where
Explore and run machine learning code with Kaggle Notebooks | Using data from multiple data sourceswww.kaggle.com](https://www.kaggle.com/viannaandresouza/exercise-select-from-where "https://www.kaggle.com/viannaandresouza/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.