The SELECT clause specifies that three columns will be in the new table:
IdNumber, Salary, and Bonus. FORMAT= assigns the DOLLAR8. format to Salary.
The Bonus column is built with the SQL expression
salary*.025
.
select IdNumber, Salary format=dollar8.,
salary*.025 as Bonus format=dollar8.
from proclib.payroll;