The CFO of company ABC wants to give every employee a 3% raise, but would like a report to confirm if this is possible. Write an SQL statement that would pull this report from the Employee table. They are requesting just the Employee ID, Current Salary, and Salary plus 3%. Salary is saved in the database for the employees annual pay.

For such a report , the sql query required would be:

SELECT emp_id, curr_salary, curr_salary*1.03 AS inc_salary FROM Employee;

Explanation:

For such a report , the sql query required would be:

SELECT emp_id, curr_salary, curr_salary*1.03 AS inc_salary FROM Employee;

In the above  sql query  employee id is emp_id , curr_salary is the current salary column.  "curr_salary*1.03" is been made because an increment of 3% means salary + salary*3% , that is , salary*1.03.

the investment was $14,174.196

explanation:

a lump sum means that the father of the example made one deposit and leave it be.

we need to know the value of a capital that generated at 4.05% per year during 28 years the sum of $48,613.24

now clearing the formula to solve for capital we got:

and we reach the answer investment = $14,174.20