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 asFIRST_NAME, the last name asLAST_NAME, and the property address asADDRESS of the owners.
Task
Provide the StayWell Property Management team with a list of all property addresses combined with the name of the owners.
Task 2:
StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests beforehand. You will need to return all the property IDs and the addresses of the properties that had plumbing service request (CATEGORY_NUMBER1).
Task
Return a list of all the property IDs and the addresses of the properties that had plumbing service requests.
Task 3:
The StayWell property management team wants to get in touch with those owners having properties larger than2,000 square feet. You need to return all the available information of the corresponding owners to the property management team.
Task
Extracted text: CATEGORY_NUM CATEGORY_DESCRIPTION 1 Plumbing 2 Heating Painting 4 Electrical Systems 5 Carpentry Furniture replacement
Extracted text: OFFICE_NUM OFFICE_NAME ADDRESS AREA CITY STATE ZIP_CODE 1 StayWell-Colombia City 1135 N. Wells Avenue Colombia City Seattle WA 98118 2 StayWell-Georgetown 986 S. Madison Rd Georgetown Seattle WA 98108