Question: Write SQL commands to solve the following depending on the HR schema given below: 4. Create a report that displays the employee id, last name
Write SQL commands to solve the following depending on the HR schema given below:

4. Create a report that displays the employee id, last name and hire date for all employees who hired after all employees whose last name ends with letter 'n'. 2pt 5. Display a list of employees that do not contain the employee whose salary is greater than 10000 or his job.id is ST_CLERK. (Hint: Use set operations to create this report) 2pt HR DEPARTMENTS department_id department name manager_id location_id LOCATIONS location_id street_address postal_code city state_province country_id JOB_HISTORY employee_id start_date end_date job_id department_id COUNTRIES country_id country_name region_id EMPLOYEES employee_id first_name last_name email phone_number hire_date job_id salary commission_pct manager_id department_id JOBS job_id job_title min_salary max_salary REGIONS region_id region_name Good Luck
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
