Sentry Page Protection
Exercise (4-10)
Jessica has another concern. In order for her to afford the monthly mortgage payment, she has to make at least $3,500 a month from the Airbnb rental. She needs help finding the neighborhoods in which the average Airbnb hosts are making more than $3,500.
Task 1:
Write a Proc SQL step to count the number of days each property was rented out in January.
Task 2:
Using the table/query created in task 1, write a Proc SQL step to calculate the monthly revenue for each property.
The monthly revenue can be calculated as follows:
Rev = (Price * 0.9) * days
Note:
Task 3
Using the query/table created in task 2, create a list of neighborhoods where the revenue in January exceeded $3,500.
Jessica has another concern. In order for her to afford the monthly mortgage payment, she has to make at least $3,500 a month from the Airbnb rental. She needs help finding the neighborhoods in which the average Airbnb hosts are making more than $3,500.
Task 1:
Write a Proc SQL step to count the number of days each property was rented out in January.
Task 2:
Using the table/query created in task 1, write a Proc SQL step to calculate the monthly revenue for each property.
The monthly revenue can be calculated as follows:
Rev = (Price * 0.9) * days
Note:
- PRICE is the price the property was rented out in January.
- CLEANING FEE is, on average, 10% of the income. The actual daily revenue is PRICE * 0.9.
- DAYS are the number of days the property was rented out in January.
Task 3
Using the query/table created in task 2, create a list of neighborhoods where the revenue in January exceeded $3,500.