Using oes2 database script.

1. For each branch with more than 7 employees, find number of Employees in each branch and sum of their commission.

2. ) List the customers first name, last name with the top three total sales(SUBTOTAL )

3. List employee number, first name, last name, total sales and total sales differences of all employees.

4. list product number, and product description, quantity on hand changing values of quantity on hand from if QOH greater than zero to 'Available', if QOH is less than or equal 0 then 'Out of Stock'

5.List all cities where there is either a branch or a customer.