# 02# SQL for Data Science

Big Query: Select, From & Where

### SELECT…FROM

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

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662174476559/1KR6iPYbC.png)

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

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662174479885/4yr_Lx6W3.gif)

### WHERE…

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

### Air Control Big Data

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

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662174484599/I-BvOk4kl.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/v1662174485881/BOKGX79Sz.jpeg)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662174487189/G_QAQf3yi.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/v1662174488466/okOfZVRdr.png)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1662174489972/v1qIJH_R1.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/v1662174491330/ib_22MFfp.png)