Answer Happy

not sure how to follow these questions, having difficulty with
them. Provided are the tables below.
6. Display the ManagerID. MEName. MLName, and number of buildings managed, for all managers that manage more than one building. Use the HAFHMORE schema. Query goes here Screen shot goes here 7. Display the ManagerID. MEName: MLName, and the number of buildings managed, for all managers. Use the HAFHMORE schema. Query goes here Screen shot goes here 8. Display the SMemberID. SMember Name, and the number of apartments that the staff members cleans, for all staff members. Use the HAFHMORE schema. Query goes here Screen shot goes here 9. Display the total amount HAFH spends on manager salaries (as TotalSalary) and the total amount HAFH spends on manager bonuses (as TotalBonus). Use the HAFHMORE schema. Format the data returned by your query with a leading dollar sign ($), comas every three digits and two decimal places. Query goes here Screen shot goes here 10. Display the answer to the following question: How many HAFH buildings have exactly 4 floors? Use the HAFHMORE schema. Query goes here Screen shot goes here

1 2 3 4. 5 6 0 N Hafhmore manager managerid mfname miname mbdate msalary mbonus mresbuildingid M12 Boris Grant 1980-06-20 60000.00 NULL B1 M23 Austin Lee 1975-10-30 50000.00 5000.00 B2 M34 George Sherman 1976-01-11 52000.00 2000.00 B4 M45 Mariana Gonzalez 1980-12-27 54000.00 NULL B5 M56 Fiona Keane 1977-10-04 57000.00 2000.00 B7 M67 Alexander Sanbom 1953-08-17 62000.00 3000.00 B8 Hafhmore buidling 1 تم لغة Hafhmore managerphone hafhmore inspector 2 3 4 5 6 7 8 9 buildingid bnooffloors bmanagerid B1 5 M12 B2 6 M23 B3 4 M23 B4 4 M34 B5 3 M45 B6 3 M45 B7 2 M56 B8 4 M67 B9 3 M67 1 Hafhmore staffmember smemberid smembemame 1028 Franz 2537 Howard 3984 Luis 4196 Arthur 5432 Brian 7652 Caroline 8467 Mariana 9876 Boris 2 3 Co w N 4 managerid M12 M12 M23 M34 M34 M45 M56 M67 M67 M67 1 2 3 4 5 الا في حالة mphone 555-2222 555-3232 555-9988 555-1003 555-9999 555-1216 555-5180 555-1327 555-3794 555-6767 2 3 4 5 6 7 8 9 10 5 6 7 8 insid insname 111 Jane 122 Niko 133 Mick 144 Bianca 155 Sergei hafhmore inspecting Hafmore cleaning 1 2 3 Hafhmore corpcilent 4 1 5 6 7 8 9 1 2 3 4 5 6 7 8 9 10 11 12 13 14 ccid ccname ccindustry cclocation ccidreferredby C111 Bling Notes Music Chicago NULL C222 SkyJet Airline Oak Park C111 C333 Xilerate Sports Chicago NULL C444 NanoCorp Broadcasting Rosemont C111 C555 EntertainUs Broadcasting Oak Brook NULL C666 Delish Inc Food Service Oak Brook C444 C777 WindyCT Music Chicago C222 C888 South Alps Sports Rosemont C777 C999 Commute Air Airline Oak Brook C111 2 3 insid buildingid datelast datenext 111 B1 2019-05-05 2020-05-05 111 B2 2019-02-02 2020-02-02 111 B7 2019-04-08 2020-04-08 122 B2 2019-04-03 2020-02-02 122 B3 2019-08-09 2020-03-03 122 B8 2019-03-19 2020-03-19 133 B3 2019-04-04 2020-04-04 133 B4 2019-05-05 2020-04-04 133 B9 2019-05-12 2020-05-12 144 B4 2019-01-11 2020-01-11 144 B5 2019-07-23 2020-07-23 155 B5 2019-08-15 2020-08-15 155 B6 2019-07-26 2020-07-26 buildingid apino B1 11 B1 21 B1 31 B1 41 B1 51 B2 11 B2 21 B2 31 B2 41 B2 51 B2 61 B3 11 B3 21 B3 31 B3 41 B4 11 B4 21 EEESSSSSS 4 smemberid 5432 5432 5432 9876 9876 9876 9876 5432 5432 1028 1028 5432 5432 8467 8467 7652 7652 5 со со умол 10 11 12 13 6 7 8 9 15 16 17

hafhmore apartments buildingid B1 anoofbedrooms 1 aptno 11 21 31 41 1 2 3 4 ccid C111 C111 C333 1 1 1 5 6 000 51 11 1 2 2 7 21 31 8 9 10 11 12 13 B1 B1 B1 B1 B2 B2 B2 B2 B2 B2 B3 B3 B3 B3 B4 B4 B4 B4 NN N N N N N N N 41 51 61 11 21 31 41 11 21 31 41 NULL NULL C222 C222 NULL NULL C111 C111 C777 C777 C555 C555 C777 C777 C222 C222 14 15 16 17 18 19 2 2 2 2 2 2 N N