Task 1: The StayWell Property Management team wants a list of all property addresses combined with the name of the owners. You will need to return three columns: the first name as FIRST_NAME, the last name as LAST_NAME, and the property address as ADDRESS of the owners. 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 5: The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team. You do not need to create a new table in the database schema. Task 6: The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents. Task 9: The StayWell property management team wants to add two additional properties and run some simulation tests relating to market coverage. Add the following properties to the PROPERTY table: However, the team does not want this data in the database once they complete their operations. You need to create a transaction with the changes rolled back.
Task 1:
The StayWell Property Management team wants a list of all property addresses combined with the name of the owners. You will need to return three columns: the first name as FIRST_NAME, the last name as LAST_NAME, and the property address as ADDRESS of the owners.
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 5:
The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team.
You do not need to create a new table in the
Task 6:
The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents.
Task 9:
The StayWell property management team wants to add two additional properties and run some simulation tests relating to market coverage. Add the following properties to the PROPERTY table:
However, the team does not want this data in the database once they complete their operations. You need to create a transaction with the changes rolled back.
![SERVICE_ID PROPERTY_ID CATEGORY_NUMBER OFFICE_ID DESCRIPTION
STATUS
EST_HOURS SPENT_HOURS NEXT_SERVICE_DATE
Problem has been confirmed.
The second bedroom upstairs is not
heating up at night.
central heating engineer has been 2
scheduled.
1
11
2
2
1
2019-11-01
1
1
A new strip light is needed for the kitchen. Scheduled
1
2019-10-02
The bathroom door does not close
Service rep has confirmed issue.
6
1
3
1
2019-11-09
properly.
Scheduled to be refitted.
New outlet has been requested for the
first upstairs bedroom. (There is currently Scheduled
no outlet).
4
4
1
1
2019-10-02
New paint job requested for the common
area (lounge).
5
8
3
Open
10
NULL
Problem confirmed. Plumber has
6
4
1
Shower is dripping when not in use.
4
2019-10-07
been scheduled.
4.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2f4e760f-fc1e-45af-8632-f9909a968d2b%2Fab52bd41-40fb-4153-a5f5-c8e29054159c%2Fldycao_processed.png&w=3840&q=75)
![RESIDENT_ID
FIRST_NAME
SURNAME
PROPERTY_ID
1
Albie
OʻRyan
1
Tariq
Khan
1
3.
Ismail
Salib
1
Callen
Beck
5
Milosz
Polansky
6.
Ashanti
Lucas
7
Randy
Woodrue
8.
Aislinn
Lawrence
3
2.
4.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2f4e760f-fc1e-45af-8632-f9909a968d2b%2Fab52bd41-40fb-4153-a5f5-c8e29054159c%2Fbnlfoev_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)