The following code provide Explanatory Analysis of Airbnb Data in 10 major cities. Answer some of the analytics questions and uncover some insights using some of the SQL intermediate techniques such as CTE, SUBQUERY, SELF-JOIN, WINDOW FUNCTION, etc.

Data is taken from Maven Playground at https://www.mavenanalytics.io/data-playground?page=4&pageSize=5. The data is premilinarily cleaned using Tableau Prep before loading in MySQL Full code and data can be found at: https://github.com/hoangp27/Exploratory-Analysis-of-Airbnb-data-in-major-cities-SQL

To maintain my SQL competency, I usually solved problem at DataLemur at: https://datalemur.com?referralCode=28cVOcbB