Question: Write an SQL query using Joins to answer the following question. Which housekeepers were assigned a condo they did not clean; who cleaned it? Display
Write an SQL query using Joins to answer the following question.
Which housekeepers were assigned a condo they did not clean; who cleaned it? Display the condo number, the assigned housekeepers number & first & last name, the date cleaned, and the number & first & last name of the cleaning housekeeper (who cleaned it).

PERSONNEL Flame Phone Hirdete Worlu Type HOUSE KEEPING L HIKIR AssignedCondos T (15 CLEANING Condokum DateCleaned FAMILIES Guest Enam Relationship Birthdate tagel CONDOS Condal Bldglum Unitium Sarft Bdrms Baths Weeklyfee GUIDES GID Certate CertRenewDate GUESTS Guest RLName RF Name CI CONDO STAYS Gondom Gentum Stactate State Phone pousef Name RESERVATIONS ACTIVITIES TotalFeepaid RIR Guest AD Description is PPP Distance Rate Numberin Party otalCost INVOICE INVOICEDETAILS Condo Num Gustum RUNamel ArtDate! Departure Date CondoFeel Details Total Invoice Total Sales TotalBilled! RID plumber Party Person Prcel Activity Tota! Detaisos PERSONNEL Flame Phone Hirdete Worlu Type HOUSE KEEPING L HIKIR AssignedCondos T (15 CLEANING Condokum DateCleaned FAMILIES Guest Enam Relationship Birthdate tagel CONDOS Condal Bldglum Unitium Sarft Bdrms Baths Weeklyfee GUIDES GID Certate CertRenewDate GUESTS Guest RLName RF Name CI CONDO STAYS Gondom Gentum Stactate State Phone pousef Name RESERVATIONS ACTIVITIES TotalFeepaid RIR Guest AD Description is PPP Distance Rate Numberin Party otalCost INVOICE INVOICEDETAILS Condo Num Gustum RUNamel ArtDate! Departure Date CondoFeel Details Total Invoice Total Sales TotalBilled! RID plumber Party Person Prcel Activity Tota! Detaisos
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
