write SQL query for this question:

Design some queries that will generate following reports using the set operators.

What jobs has any one employee held? This will be the JOB_ID for the employees current

job (in EMPLOYEES) and all previous jobs (in JOB_HISTORY). If the employee has held a

job more than once, there is no need to list it more than once. Use a substitution variable to

prompt for the EMPLOYEE_ID and display the job title(s). Employees 101 and 200 will be

suitable employees for testing.