10

SELECT department_id, last_name, job_id
FROM employees
WHERE department_id in (select department_id from departments WHERE department_name = 'Executive');

8

SELECT employee_id, last_name, salary
FROM employees
WHERE salary > (select avg(salary) from employees) and
department_id in (select department_id from employees where last_name '%u%');