Question

1. List names of all employees who are not from Department A00. 2. What is the average of all employee salaries? 3. Which employees earn more than average? 4. List names and salaries of employees earning more than $35,000. 5. Increase Ms. Haas's salary to $500,000 and then list her new monthly salary.

Answer 1

Please find schedule attached

Answer and Explanation:

1. Names of employees who are not from Department A00 include employees whose work department isn't A00 such as:

Michael Thompson, Sally Kwan, John Geyer, Irvin Stern etc(please refer to attachment)

2. Average of all employees salary = total employees salary /number of employees = $627415/25=$25096.6

3. There are 16 employees earning above the average salary of the employees, such as Christine Haas, Sally Kwan etc

4. There are 6 employees earning above $35000 such as Christine Haas, Michael Thompson, Sally Kwan, John Geyer etc

5. Ms. Haas currently makes $633000 yearly($52750 per month). If she makes $500000 per year then her salary per month will be $500000/12=$41666