What can airbnb do to increase the number of bookings?

I just need you to send the codes to me and I’ll run it myself

Submit the SQL code and output for the questions as a PDF.
Billboard Top 100
dataset: billboard_top_100_year_end
● What were the top songs for the past 30 years?
● Which artists have had the most top 10 songs over the years? What were the songs?
● Which artists have been on the billboard top 100 the most in the past 10 years?
● Who is the best artist in the past 50 years? What metrics would you use to answer this question?
Online Retail
datasets: online_retail
● Create a new column ‘total_cost’. (hint: quantity * unitprice)
● What is the total amount of purchases by customers?
○ Who has spent the most?
○ Who has spent the least?
● Which country has the highest total amount sold?
● How many products have been bought by each customer?
● Find the top 10 customers for each country by total spend?
● Find the total sales for each product by Country?
Airbnb
datasets.airbnb_searches, datasets.airbnb_contacts (hint: JOIN ON ‘id_user’, ‘ds_checkin’, ‘ds_checkout’)
● How many rows are there in the JOINed dataset?
● From here on only select these columns in the query:
○ id_user
○ ds_checkin
○ ds_checkout
○ n_searches
○ n_nights
○ origin_country
○ filter_neighborhoods
○ n_guests
○ N_messages
● How many users are searching for accomodations for 2 guests? (hint: n_guests tells you how many guests each user has in their party)
● Provide the top 10 countries by user count. Hints:
○ user GROUP BY
○ count the id_users by origin_country
○ use ORDER BY to find the top 10 countries by user count
● What is the average number of messages exchanged between guests and hosts? (hint: use n_messages)
● How many users are searching for 5 nights or more? (hint: use n_nights)
● How many nights are most people searching for when trying to book a host?
● What’s the acceptance rate of requests?
● What can airbnb do to increase the number of bookings?

Last Completed Projects