Question

Imagine you want to identify employees who are eligible for promotions based on their years of experience and current salary. Write an Oracle SQL query to retrieve the employee ID, name, department, and salary of employees who have more than 5 years of experience and earn more than $95,000 per year.

Answer 1

SELECT employee_id, employee_name, department, salary

FROM employees

WHERE years_of_experience > 5 AND salary > 95000;