Query the Data

To retrieve all employees in a specific department with a salary greater than $60,000, use the following query:

SELECT first_name, last_name, salary
FROM employees
WHERE salary > 60000 AND department_id = 2;