MySQL WORKBENCH STAYWELL MODULE 5

OFFICE table

OWNER table

PROPERTY table

RESIDENTS table

SERVICE_REQUEST table

SERVICE_CATEGORY table

Please help with the following question in MySQL WorkBench:

New Task: For every complete request for furniture replacement, list the property ID, management office number, address estimated hours, spent hours , owner number, and owners last name.

I have this so far but I need help changing it to get the right answer.

SELECT PROPERTY.PROPERTY_ID, PROPERTY.OFFICE_NUM, PROPERTY.ADDRESS, SERVICE_REQUEST.EST_HOURS, SERVICE_REQUEST.SPENT_HOURS, OWNER.OWNER_NUM, OWNER.LAST_NAME FROM PROPERTY, SERVICE_REQUEST, OWNER WHERE PROPERTY.PROPERTY_ID = SERVICE_REQUEST.PROPERTY_ID AND PROPERTY.OWNER_NUM = OWNER.OWNER_NUM

The output should look like this please and thank you:

OWNER_NUM LAST_NAME FIRST_NAME ADDRESS CITY STATE ZIP_CODE AK102 Aksoy Ceyda 411 Griffin Rd. Seattle WA 98131 Bianchi Nicole 7990 Willow Dr. BU106 Burke Ernest 613 Old Pleasant St. NewYorkTwinFallsNYID1000583303 Cole Meerab 9486 Circle Ave. Jones Ammarah 730 Military Ave. OlympiaSeattleWAWA9850698126 Kowalczyk Jakub 7431 S. Bishop St. Lopez Janine 9856 Pumpkin Hill Ln. Moore Elle-May 8006 W. Newport Ave. Patel Makesh 7337 Sheffield St. Redman Seth 7681 Fordham St. SI105 Sims Haydon 527 Primrose Rd. Portland WAWANVWAWAOR982269821389508981199811997203 . RESIDENT_ID FIRST_NAME SURNAME PROPERTY_ID 1 Albie ODRyan 1 2 Tariq Khan 1 3 Salib 1 4 Beck 2 5 6 7 8 9 Monique 10 Amara Dejsuwan 4 CATEGORY_NUM CATEGORY_DESCRIPTION Plumbing 2 Heating 3 Painting 4 Electrical Systems 5 Carpentry 6 Furniture replacement \( \begin{array}{lllllll}\text { Property_ID } & \text { Office_Num } & \text { Address } & \text { Est_Hours } & \text { Spent_Hours } & \text { Owner_Num } & \text { Last_Name } \\ 12 & 2 & 2 \text { Bow Ridge Ave. } & 2 & 0 & \text { RE107 } & \text { Redman }\end{array} \)