USE MYSQL TO SOLVE PROBLEM

Which housekeepers were assigned a condo they did not clean; who cleaned it? Display the condo#, the

assigned housekeeper's number first last name, the date cleaned, and the number first last name

of the cleaning housekeeper (who cleaned it).

PERSONNEL (PID, LName, FName, Phone, HireDate, Mgr#, PType] Ftype: housekeeping or activity guide Mgre - employee's manager number AssignedCondos: the condo HOUSEKEEPING (HKID, AssignedCondos) numbers that have been assigned for cleaning. CLEANING (Condo#, DateCleaned, HKID) Bdems - number of bedrooms in unit CONDOS (Condo#, Bidgil, UnitNum, Sqrift, Bdrms, Baths, WeeklyFee) Baths - number of baths in unit CONDOSTAYS (Condo#, Guest#, StartDate, EndDate] StartDate -arrival EndDate - departure FAMILIES (Guest#, FName, Relationship, Birthdate] Guest's children: Relationship: son/daughter GUESTS (Guest#, ALName, RFname, City, State, Phone, SpouseFName) Riname - last name of registered guest RFname - first name of registered guest INVOICE (INV#, Condo#, Guest#) INVOICEDETAILS (INVE, RID, AID) RDate - date of reservation RESERVATIONS (RID, Guest#, AID, GID, RDate, NumberinParty) NumberinParty - number of people participating in the group His-number hours for the activity ACTIVITIES (AID, Description, Hrs, PPP, Distance, Type] PPP - price per person Distance - length in miles GUIDES (GID, CertDate, CertRenewDate)PERSONNEL PID LName FName Phone Hiredate Mgra PType HOUSEKEEPING HKID AssignedCondos (1,5) CLEANING Condos DateCleaned HKID FAMILIES CONDOS Guest Condo# Fname Bido# Relationship GUIDES UnitNum Birthdate GID SqrFt [Age] CertDate Bdrms CertRenewDate Baths WeeklyFee GUESTS Guest# RLName RFName City |State CONDOSTAYS Phone Condos SpouseFName Guest StartDate RESERVATIONS ACTIVITIES EndDate RID AID [TotalFeePaid] Guest# Description AID GID PPP RDate Distance NumberinParty Type [TotalCost] INVOICE INV# INVOICEDETAILS Condo# Guest# INV# RID (RLName] AID [ArrivalDate] [Departure Date] [NumberInParty] [CondoFee] [Person Price] [Details Total] [ Activity Total] [Invoice Total] [Details Total] Sales Tax] TotalBilled]