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:

Task: List the first and last names of all owners who own a two-bedroom property. Use the IN operator in your query.

I have followed Chegg Guide lines and only asked one question. Please and thank you! I appreciate all the help. All questions are being posted separately.

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