Solve this using SQL Oracle Developer

With the recent increase in IT Support requests, the company decided to strengthen their IT abilities. As a result, it was decided to promote Valli Pataballa to IT Support Manager. Also, Alexander Hunold is promoted to IT Manager

Create a job position titled IT Manager. ID for the position is IT_MAN. Also salary range for the position is between 7000 and 13000 (5 points).

Create a job position titled IT Support Manager. ID for the position is ITS_MAN. The salary for the position ranges between 6000 and 11000 (5 points).

Update the position of Alexander Hunold from Programmer to IT Manager. (5 points)

Update Valli Pataballas job_id with the new job id for IT Support Manager. Also, his salary is increased by 2000. Remember his manager is not Alexander Hunold but Lex De Haan, an Administration Vice President. (10 points)

Apply the all recent changes of job positions to Job history and department table.(Hints: Take a look at the job_history table, you can see that there are five columns: employee_id, start_date, end_date, job_id, department_id. You need to add job history records into the table regarding with the previous and current position of the newly promoted two employees. In addition to the 2 managers, you need to record the five new employees) (10 points)