SQL Question

Please use the following database

https://codeshare.io/aVKqm6

Here is the ERD Diagram of the question/database https://drive.google.com/open?id=0B_OOaWV7RgsRUWczZFdRYzZZa0E Questions:

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

2. List all employees who earn more than the average commission in their branch

3. (function) List the customer no, first name, and last name with the bottom eight total sales (hint use SUBTOTAL).

4. (function) List employee number, first name, last name, total sales and total sales differences of all employees (hint use SUBTOTAL) .

5. (Function) List product no, and product description, quantity on hand changing values of quantity on hand from if QOH greater than zero to 'In Stock', if QOH is less than or equal 0 then 'Out of Stock'.

6. (Use PL/SQL) List all employees (employee no, first name, last name, branch no) who are not working in branch 104 and who earn commission more than all employees working in branch 104 , sort the result by branch no .

7. (Use PL/SQL) List Employees (first name, last name and city) who work in a Mankato branch.

8. (Use PL/SQL) List all cities where there is branch but not a customer.