Please solve in SQL database

1) Return all employees whose last names start with St.

2) I was hired by Oracle after May 1998 but before June of 1999. My salary is less than $8000 per month, and I have an en in my last name.

3) Sort customers name, address, phone in alphabetical order?

4) The customers table where the customer_id is between 4000 and 4999 ?

5) Select parts order from february 2, 2014 until february 28, 2014? From parts_order table?

6) Select all employees where commission_pct has null values?

7) Show all employees last name, where the first two characters is 'Sm' and the last two characters is 'th'.

18) Faculty has decided to give all staff members a 5% raise. Create output as shown: Faculty id, first name, last name, salary and bonus salary column with raise;

9) Show all students where their home phone number is null ?

10) You want to know the annual salary of all faculty. How will you show that?