Please provide SQL statements, on a separate sheet that answer the following:
- Display Oracle database employee last_name and salary for employee_ids between 100 and 102. Include a third column that divides each salary by 1.55 and rounds the result to two decimal places.
- Display employee last_name and salary for those employees who work in department 80. Give each of them a raise of 5.33% and truncate the result to two decimal places.
Use a MOD number function to determine whether 38873 is an even number or an odd number.
Use the DUAL table to process the following numbers:
- 845.553 - round to one decimal place
- 30695.348 - round to two decimal places
- 30695.348 - round to -2 decimal places
- 2.3454 - truncate the 454 from the decimal place
- Divide each employee’s salary by 3. Display only those employees’ last names and salaries who earn a salary that is a multiple of 3.
- Divide 34 by 8. Show only the remainder of the division. Name the output as EXAMPLE.