PLEASE DO NOT COPY PASTE FROM CHEGG/OTHERWISE I'LL REPORT YOU

Exercises for Self-Practice Try to compare your answers with your classmates after you've completed the following exercises on your own. [If you're using the Live Oracle SQL website, these tables are hr.jobs and hr employees.] Assume the source and target tables are the HR schema's JOBS and EMPLOYEES tables, respectively. The columns EMPLOYEES ID, SALARY, and COMMISSION PCT are found in the EMPLOYEES table. The columns JOB ID and JOB TITLE in the JOBS database are JOB ID and JOB TITLE, respectively. Based on the shared JOB ID field, the data in these two tables are linked. Answer the following questions: 1. Fill out the Jobs table with the values listed below. Min salary Max salary Job id Job title Job id Job title Job id Job id Job id Job id Job HR Human Resources 5400 8000 TR Trainer 5000 6000 Query 1: For all jobs in the jobs table, display job id and job title. Query 2: For all employees in the employees table, display employee id, salary, and commission pct. Query 3: Using an inner join, display job id, job title, employee id, salary, and commission pct for only those employees whose salary is greater than 15000. Query 4: Using a left outer join, display job id, job title, employee id, salary, and commission pct from both the jobs and employees tables for only employees with salaries greater than 5000. . Query 5: Using a right outer join, display job id, job title, employee id, salary, and commission pct from both the jobs and employees tables for just those employees whose pay is greater than 5000.. Query 6: Using a full outer join, display job id, job title, employee id, salary, and commission pct from both the jobs and employees tables for only employees with salaries greater than 5000. Query 7. From both jobs and employees, display job id, job title, employee id, pay, and commission pct