Please help solve in SQL database

1)

ADD_MONTHS command

What is the date 10 years or 120 months from now? Label the column Future. 2)

INSTR command Whats the position of I in Oracle Internet Academy?

3)

USING RPAD command: Starting with the string Oracle Internet Academy,pad the string to produce: Oracle$$$Internet$$$Academy

4)

SUBSTR command

Write a query to return the first character of the first name concatenated to the last_name, the salary, and the department id for employees working in department 20. Give the first expression an alias of Name. Use the EMPLOYEES table.

5)

Write SELECT statement that will always return the last names in alphabetical order from employees table?

6)

Because I have been working for Oracle since the beginning of 1996, I make more than $9000 per month. Because I make so much money, I don't get a commission

7)

Write a statement that will return only the DJs on Demand CDs with years greater than 2000 but less than 2003. Display both the title and year.

8) Show faculty names, their salary and show salary bonus of 1000 for all faculty employees that where hired from 2000 only 9)

Find all faculty which make their salary are no less then 2000 plus no more then 7000 10)

Write a statement that will return the Oracle database employees employee ID and their starting hire dates between January 1, 1997 and today. Display the result ordered from most recently hired to the oldest.