# 02# SQL for Data Science

Big Query: Select, From & Where

### SELECT…FROM

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832811161/gHt4Yh_JK.png)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832812617/xvEbaFLXt.png)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832814306/XSWpZL3ah.gif)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832816626/Qbmn7gFxp.gif)

### WHERE…

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832818425/UtM8xsc3L.png)

### Air Control Big Data

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832819770/GbYM7XuI3.png)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832821320/4Y76C_Ciq.png)

[**OpenAQ**  
*OpenAQ is a community of scientists, software developers, and lovers of open environmental data*openaq.org](https://openaq.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 sources*www.kaggle.com](https://www.kaggle.com/viannaandresouza/02-sql-data-science "https://www.kaggle.com/viannaandresouza/02-sql-data-science")[](https://www.kaggle.com/viannaandresouza/02-sql-data-science)

### Air Quality Control

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832822893/WCTGe1aFJ.jpeg)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832824198/7UjQhKpFu.png)

[**Exercise: Select, From & Where**  
*Explore and run machine learning code with Kaggle Notebooks | Using data from multiple data sources*www.kaggle.com](https://www.kaggle.com/viannaandresouza/exercise-select-from-where "https://www.kaggle.com/viannaandresouza/exercise-select-from-where")[](https://www.kaggle.com/viannaandresouza/exercise-select-from-where)

### Diference Tables vs DataSet

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832825598/JekbQ0khj.png)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832826987/fFRsIUNa5.png)

### 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.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662832828380/26G0_s5LE.png)