subject

6.Display the ManagerID, MFName, MLName, and number of buildings managed, for all managers that manage more than one building. Use the HAFHMORE schema. 7.Display the ManagerID, MFName, MLName, and the number of buildings managed, for all managers. Use the HAFHMORE schema.

8.Display the SMemberID, SMemberName, and the number of apartments that the staff members cleans, for all staff members. Use the HAFHMORE schema.

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.

10.Display the answer to the following question: How many HAFH buildings have exactly 4 floors? Use the HAFHMORE schema.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 00:30
Quic which one of the following is the most accurate definition of technology? a electronic tools that improve functionality b electronic tools that provide entertainment or practical value c any type of tool that serves a practical function d any type of tool that enhances communication
Answers: 1
question
Computers and Technology, 23.06.2019 13:50
Explain how email technologies enable the exchange of messages between users. find out the typical parts of an email address and explain each part.
Answers: 1
question
Computers and Technology, 23.06.2019 18:30
Where can page numbers appear? check all that apply. in the header inside tables in the footer at the bottom of columns at the top of columns
Answers: 1
question
Computers and Technology, 24.06.2019 11:00
Need fast im timed in a paragraph of 125 words, explain at least three ways that engineers explore possible solutions in their projects.
Answers: 2
You know the right answer?
6.Display the ManagerID, MFName, MLName, and number of buildings managed, for all managers that mana...
Questions
question
Mathematics, 20.04.2021 22:30
question
Physics, 20.04.2021 22:30
question
History, 20.04.2021 22:30
question
Mathematics, 20.04.2021 22:30
Questions on the website: 13722360