write oracle SQL code $($with creating all tables that are required$)$

Produce a list of all employees whose salary is more than $3000$

List all employees who earn less than $1500$

List the name and salary of employee number $7900$

List the names and salaries of all managers

List the hiredates and salaries of all employees in department $10$

List the names and department numbers of the employees whose

manager number is $7698$