E5.2.18 Display the CCName of the client and the CCName of the client who referred him or her, for every client referred by a client in the Music industry. E5.2.19 Display the BuildingID, AptNo, and ANoOf- Bedrooms for all apartments that are not leased. E5.2.20 Display the ManagerID, MFName, MLName, MSalary, and MBonus, for the manager with the lowest total compensa- tion (total compensation is defined as the salary plus bonus). INSPECTOR InsID InsName 111 Jane 122 Niko 133 Mick BUILDING BuildingID BNoOf Floors BManagerID | B1 5 M12 B26 M23 B34 M23 B4 4 M34 APARTMENT BuildingID AptNo ANOOf Bedrooms CCID INSPECTING InsID BuildingID 111 B1 41 B1 B1 B2 111 B2 C111 C222 122 TB2 21 | 11 31 11 11 B2 B3 B4 Date Last DateNext 5.5.2019 5.5.2020 2.2.2019 2.2.2020 3.4.2019 2.2.2020 9.8.2019 3.3.2020 4.4.2019 4.4.2020 5.5.2019 4.4.2020 1 2 2 2 2 122 133 C777 0777 | вз B3 B4 133 MANAGER ManagerID MFName MLName MB Date MSalary MBonus MResBuildingID M12 Boris Grant 6.6.1988 60000 M23 Austin Lee 2.2.1983 50000 5000 B2 M34 George Sherman 7.8.1984 52000 2000 1 4 B1 B1 21 CLEANING BuildingID AptNo SMemberID 5432 B1 41 9876 B2 11 9876 31 5432 5432 B4 11 7652 B2 B3 11 MANAGERPHONE ManagerID MPhone M12 555-2222 M12 555-3232 M23 555-9988 M34 555-9999 STAFFMEMBER SMemberID SMember Name 5432 Brian 9876 Boris 7652 Caroline CORPCLIENT CCID CCName CCIndustry C111 BlingNotes Music C222 SkyJet Airline C777 Windy CT Music C888 SouthAlps Sports CCLocation | CCIDReferredBy Chicago Oak Park C111 Chicago C222 Rosemont C777