Task 3: The StayWell property management team wants to get in touch with those owners having properties larger than 2,000 square feet. You need to return all the available information of the corresponding owners to the property management team. Task Return a list of all the property owners having properties larger than 2,000 square feet. 1 Task 4: The StayWell maintenance team wants to minimize the number of planned visits to properties. The team wants to learn all the properties that have different planned service dates. You need to return all available data in the SERVICE_REQUEST table, where requests are made for the same property with a different NEXT_SERVICE_DATE. Task Return a list of all properties where service requests are made with different NEXT_SERVICE_DATE values.
Task 3:
The StayWell property management team wants to get in touch with those owners having properties larger than 2,000 square feet. You need to return all the available information of the corresponding owners to the property management team.
Return a list of all the property owners having properties larger than 2,000 square feet.
Task 4:
The StayWell maintenance team wants to minimize the number of planned visits to properties. The team wants to learn all the properties that have different planned service dates. You need to return all available data in the SERVICE_REQUEST table, where requests are made for the same property with a different NEXT_SERVICE_DATE.
Return a list of all properties where service requests are made with different NEXT_SERVICE_DATE values.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
