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.

both are integral parts of a corporate balance sheet. the cash flow statement, or statement of cash flows, measures the sources of a company's cash and its uses of cash over a specific time period. the income statement measures a company's financial performance, such as revenues, expenses, profits or losses over a specific time period (in fact, it's sometimes called a statement of financial performance).

a cash flow statement shows exactly how much money a company has received and how much it has spent, traditionally over a period of one month. it captures the current operating results and changes on the balance sheet, such as increases or decreases in accounts receivable or accounts payable, and does not include noncash accounting items such as depreciation and amortization. the cash flow generally comes from revenue received as a result of business activity, but it may be augmented by funds available as a result of credit. a cash flow statement is used to determine the short-term viability and liquidity of a company, specifically how well it is positioned to pay its bills and vendors.

you get one warning and if you do something to violate the guidelines of after that you get kicked off.

mark as