Purpose
The purpose of this assignment is to give students practical experience using SQL commands to retrieve, update, insert, and delete data.

Instructions
Complete the following steps:
Start Assignment - Complete reading and reviewing all the learning resources specified for this module.
Access the Oracle Cloud Database or Oracle Apex.
[Instructor provides link here]
[Instructor provides the username and password]
Execute the following script to create an Oracle database schema. M06 Create Schema Script
Write SQL commands for the following exercises.
List all the distant employees, your output should include the employee id, name, email, phone number, hire date, and salary. You can use the DESCRIBE (DESC) command to view all the columns available in a table.
EXAMPLE: DESC EMPLOYEE;
List all the job ids and titles with a max salary less than 15000 and a min salary greater than 9000.
List all the rows in the locations table where the country is equal to United States.
Insert a row containing your information into the employees' tables, you'll need to include the department which you will be working for, as well as the manager you will be reporting too. Remember the PK must be unique.
Insert into the dependent table any dependents you may have, entries can include children, spouse, parents, and etc...
Update the hire date from the employee with the id 192 to 2020-10-16 in the employee table.
Now issue a commit command, note a commit Links to an external site.will permanently save the data to the database. This step is not applicable if your using Apex.
Delete the row with job id equal 17 from the jobs table, but do not commit. Issue a select command for the record deleted.
Now issue a rollback Links to an external site.command. The rollback command will restore the data to its original state prior to applying any modifications. Now reissue the select command for the record which was previously deleted. This step is not applicable if your using Apex.
Retrieve all the tuples stored in the countries table. The output should be displayed in descending order based on the country's id.
Retrieve the columns region name, country name from the regions and country tables, your query will need to reference both relations. Link the two tables by matching values in related attributes.