(USING ORACLE APEX)

Question 1. Select the lowest salary, the most recent hire date, the last name of the person who is at the top of an alphabetical list of employees, and the last name of the person who is at the bottom of an alphabetical list of employees. Select only employees who are in departments 50 or 60.

(I tried this SQL query for the above question but it still giving me an error)

SELECT MIN(salary) AS lowest_salary, MAX(hire_date) AS most_recent_hire_date, (SELECT last_name FROM employees WHERE department_id IN (50, 60) ORDER BY last_name ASC FETCH FIRST 1 ROWS ONLY) AS first_employee, (SELECT last_name FROM employees WHERE department_id IN (50, 60) ORDER BY last_name DESC FETCH FIRST 1 ROWS ONLY) AS last_employee FROM employees WHERE department_id IN (50, 60);