Teradata Viewpoint gives you access to the HAFH database used in Exercise $5\mathrm{.}2$ of your textbook. The full information of the database $($tables and columns can be found in figure $5\mathrm{.}40$c of your book, refer to that image when you are completing the exercise. In this exercise you will only use the hafh database. To access the databae you will need the following statement: db$\_$jukiced$2\_$hafh

$4.$ Complete Exercise $5\mathrm{.}2$ numbers $1-20($each worth $2$ points$).$ Take a screenshot of each query statement and results and paste the image into the same Word document used in Part I. Make sure images are legible and that you number each item carefully. If you do what I did and run several queries at once be sure to take a screenshot of each query.E$5\mathrm{.}2\mathrm{.}1$ Display all the records in the table STAFFMEMBER.

E$5\mathrm{.}2\mathrm{.}2$ Display the BuildingID and number of floors in the building for all buildings.

E$5\mathrm{.}2\mathrm{.}3$ Display the CCID, CCName, and CCIndustry for all corporate clients, sorted alphabetically by CCName.

E$5\mathrm{.}2\mathrm{.}4$ Display all the records in the table STAFFMEMBER for staff members whose Member Name begins with a letter B$.$

E$5\mathrm{.}2\mathrm{.}5$ Display the BuildingID, AptNo, and ANoOfBedrooms for all apartments that have more than one bedroom.

E$5\mathrm{.}2\mathrm{.}6$ Display the answer to the following question: How many HAH buildings have exactly $4$ floors?

E$5\mathrm{.}2\mathrm{.}7$ Display the total amount HAH spends on manager salaries $($as TotalSalary$)$ and the total amount HAH spends on manager bonuses $($as TotalBonus$).$

E$5\mathrm{.}2\mathrm{.}8$ Display the ManagerID, MFName, MLName, MSalary, and MBonus, for all managers with a salary greater than

$$50,000$ and a bonus greater than $$1,000.$

E$5\mathrm{.}2\mathrm{.}9$ Display the BuildingID, BNoOfFloors, and the manager's MFName and MLName for all buildings.

E$5\mathrm{.}2\mathrm{.}10$ Display the MFName, MLName, MSalary, MBdate, and number of buildings that the manager manages for all managers with a salary less than $$55,000.$

E$5\mathrm{.}2\mathrm{.}11$ Display the BuildingID and AptNo for all apartments leased by the corporate client WindyCT.

E$5\mathrm{.}2\mathrm{.}12$ Display the InsID and InsName for all inspectors that have any inspections scheduled after $1-$APR$-2020.$ Do not display the same information more than once.

E$5\mathrm{.}2\mathrm{.}13$ Display the ManagerID, MFName, MLName, and MSalary, for all managers with a salary greater than the average manager's salary.

E$5\mathrm{.}2\mathrm{.}14$ Display the ManagerID, MFName, MLName, and the number of buildings managed, for all managers.

E$5\mathrm{.}2\mathrm{.}15$ Display the ManagerID, MFName, MLName, and number of buildings managed, for all managers that manage more than one building.

E$5\mathrm{.}2\mathrm{.}16$ Display the SMemberID, SMemberName, and the number of apartments that the staff members cleans, for all staff members,

E$5\mathrm{.}2\mathrm{.}17$ Display the SMemberlD and SMemberName of staff members cleaning apartments rented by corporate clients

whose corporate location is Chicago. Do not display the same information more than once

E$5\mathrm{.}2\mathrm{.}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.

E$5\mathrm{.}2\mathrm{.}19$ Display the BuildingID, AptNo, and ANoOfBedrooms for all apartments that are not leased.

E$5\mathrm{.}2\mathrm{.}20$ Display the ManagerID, MFName, ML$.$Name, MSalary, and MBonus, for the manager with the lowest total compensation $($total compensation is defined as the salary plus bonus$).$

im so lost where do i start im using terra veiwpoint