Solved programming problem

Show each employees employee_id, and yearly total salary with commission he receives

Source code

SELECT EMPLOYEE_ID,SALARY*12 *(1 + (COMMISSION_PCT DIV 100))

FROM employees;
Join the discussion

Add your comment