Please help Solving in SQL database

1)

TRUNC command for salary

Display employee last_name and salary for those employees who work in department 80. Give each of them a raise of 5.333% and truncate the result to two decimal places.

2)

Select all the students whose last names end with e, and change the heading of the column to show Names of Students.

3) Show all students id, first name, last name whose first name that doesn't start with second letter "e" ?

4) Show all faculty id, first name, last name, dob, but only dob before May 2, 1976 ? 5)

Show faculty id, first name, last name but only for faculty id with number 11115

6)

John has a yearly salary of 135000 dollars. Create that sentence with sql command 7) Show employees that do not work for IBM, Oracle, AWS ?

8)

Show all orders comming from state of Florida and food company is Hershey from order id that is less 1000

9)

Remove duplicate from state, country from order table but total order must be higher then 50 and must be in state alphabetical order

10)

Show all numbers which you know 6 numbers but you forgot the 7 digit: