Create HAFH Database and Populate 1. Create a database named HAFH. 2. Download the HAFH script. 3. Execute the script to create tables, database structure, and insert data into the HAFH database. Create and execute queries to answer the following business questions. 1. The business owner has asked for a list of all staff. Provide the list. 2. A client is interested in renting an apartment in Building 4. They require a 2 or 3 -bedroom unit. Provide a list of all 2 and 3-bedroom apartments in Building 4. 3. Someone has complained about one of the staff. Show all apartments cleaned by staff member Brian except those in building B2. Include building ID and Apartment number. 4. There's a plan to give a 5% raise to all managers. Create a query that shows all managers, their current salary, and what their new salary would be after the raise. Include appropriate columns in the results and use appropriate column names. 5. The business owner wants to know the average salary, highest and lowest salaries of the managers. Be sure to include salary and bonus in your calculation. Give the column headers appropriate names. Hint: the result will be one row with summary data. 6. How many apartments are there in total? 7. The business owner has asked for a list of all corporate clients and the manager responsible for each apartment they rent. Sort the results in ascending order by client name. 8. The business owner is renewing the insurance policy for the property and has asked for a list of all buildings with more than 3 stories tall. 9. WindyCT is one of our best clients. The business owner has asked for a list of all apartments they lease. Include appropriate columns in the result. 10. The managers are trying to determine the scheduling availability of inspectors. They need a list of all inspectors whose next inspection is scheduled after 1-JAN-2014. Do not display the same information more than once