Sentry Page Protection
Exercise (5-10)
Jessica has decided to invest in a property in one of the three neighborhoods below:
Task 1:
Ideally, she'd like to invest in a neighborhood that has fewer competitors. The lower the number of the properties in the neighborhood, the better.
Write a Proc SQL step to compute the number of properties in each of the three neighborhoods above. Which neighborhood has the lowest number of listings?
Task 2:
In addition, she'd like to invest in the neighborhood where the average rating is below 4.
Write a Proc SQL step to compute the average rating for each of the three neighborhoods.
Is there any neighborhood where the average rating is above 4?
Jessica has decided to invest in a property in one of the three neighborhoods below:
- Dufferin Grove (83)
- Broadview North (57)
- Trinity-Bellwoods (81)
Task 1:
Ideally, she'd like to invest in a neighborhood that has fewer competitors. The lower the number of the properties in the neighborhood, the better.
Write a Proc SQL step to compute the number of properties in each of the three neighborhoods above. Which neighborhood has the lowest number of listings?
Task 2:
In addition, she'd like to invest in the neighborhood where the average rating is below 4.
Write a Proc SQL step to compute the average rating for each of the three neighborhoods.
Is there any neighborhood where the average rating is above 4?