If you want to explore data

If we want of find dataset. We can search in Kaggle or any website that “Opendata”

If I want to import the data from csv

1. Go to the database we want
2. Find the table
3. Click right and import

Find the certain info within the column.

1. If we want to find certain info, we can order like this

SELECT * FROM airbnb_ny WHERE neighbourhood_group = "Brooklyn";

1. It only groups that we asked before

Let’s Play

Question

show the data airbnb that shows the price lesser than 100 USD for a Private room

SELECT * FROM airbnb_ny WHERE price <= 100  ORDER BY room_type;

The result