To encourage employee ownership of the company's common shares, KL Corp. permits any of its employees to buy shares directly fro
m the company through payroll deduction. There are no brokerage fees and shares can be purchased at a 12% discount. During May, employees purchased 10,000 shares at a time when the market price of the shares on the New York Stock Exchange was $12 per share. KL will record compensation expense associated with the May purchases of:
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.
