<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' stroke='%23337EA9' fill='none' stroke-linecap='round' stroke-linejoin='round'%3e%3cpath stroke='none' d='M0 0h24v24H0z' fill='none'/%3e%3ccircle cx='12' cy='11' r='3'/%3e%3cpath d='M17.657 16.657 13.414 20.9a2 2 0 0 1-2.827 0l-4.244-4.243a8 8 0 1 1 11.314 0z'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' stroke='%23337EA9' fill='none' stroke-linecap='round' stroke-linejoin='round'%3e%3cpath stroke='none' d='M0 0h24v24H0z' fill='none'/%3e%3ccircle cx='12' cy='11' r='3'/%3e%3cpath d='M17.657 16.657 13.414 20.9a2 2 0 0 1-2.827 0l-4.244-4.243a8 8 0 1 1 11.314 0z'/%3e%3c/svg%3e" width="40px" /> Navigation bar

</aside>

<aside> <img src="/icons/light-bulb_blue.svg" alt="/icons/light-bulb_blue.svg" width="40px" /> Summary

Goal

This project aimed to analyze the prices of NYC Airbnb listings to identify the most and least expensive neighborhoods and demonstrate how to achieve that using Window Functions in SQL.

Process

For this project, I used the below outline:

1. Importing the CSV file containing the Airbnb data into a PostgreSQL database.
2. Creating a table to store the data.
3. Applying window functions to perform advanced analysis.

Insights

1. Manhattan has both the most and least expensive listings, with $10,000 being the highest price and $500 being the lowest (I assumed a $500 price as a baseline since there were houses listed with no price)
2. There are 59 listings with the exact price of $1,000. </aside>

<aside> <img src="/icons/checkmark_blue.svg" alt="/icons/checkmark_blue.svg" width="40px" /> Which are the top 3 most expensive Airbnb listings in NYC?

These are the top three most unique and luxurious options: 1-BR Lincoln Center in Manhattan, the Luxury 1 bedroom apt. With stunning Manhattan views in Brooklyn, and the Furnished room in Astoria apartment in Queens, all listed at $10,000.

</aside>

<aside> <img src="/icons/checkmark_blue.svg" alt="/icons/checkmark_blue.svg" width="40px" /> Which is the neighborhood group with the most expensive Airbnb listings in NYC?

The most expensive neighborhood is Manhattan, with 6 of the ten highest prices in Airbnb listings.

</aside>

<aside> <img src="/icons/checkmark_blue.svg" alt="/icons/checkmark_blue.svg" width="40px" /> Where are located the 3 less expensive listings?

When we select all listings above $500 (The reasonable price I accepted), the 3 less expensive listings are located in the Financial District and Midtown (both from Manhattan), and Williamsburg, located in Brooklyn.

</aside>

<aside> <img src="/icons/checkmark_blue.svg" alt="/icons/checkmark_blue.svg" width="40px" /> How many listings are priced at $1,000?

Most of those listings are located in Manhattan.

</aside>

Detailed Report — For More Information