Computers and Technology, 09.07.2021 20:50 idcatall5

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.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 02:00

Which of the following is not a source of sustainable raw materials? a) coal mine b) flick of sheep c) cotton plantation d) line forest.

Answers: 2

Answer

Computers and Technology, 23.06.2019 06:10

The head restraint should be adjusted so that it reaches a.the top of your ears b.the base of your skull c.the top of the head

Answers: 1

Answer

Computers and Technology, 24.06.2019 09:10

to change the number of rows and columns displayed by the excel object a. select the object and drag a size handle on the active object. b. deselect the object and drag a size handle of the object. c. deselect the object and drag a row or column divider of the object. d. select the object and drag a row or column divider on the active object.

Answers: 2

Answer

Computers and Technology, 24.06.2019 14:00

In simple terms, how would you define a protocol?

Answers: 2

Answer

You know the right answer?

6.Display the ManagerID, MFName, MLName, and number of buildings managed, for all managers that mana...

Questions