SELECT last_name, hire_date
FROM employees
WHERE department_id =
                    (SELECT department_id
                     FROM employees
                     WHERE last_name = '&&var')
AND last_name <> '&&var';


SELECT employee_id, last_name, salary
FROM employees
WHERE salary >
              (SELECT AVG(salary)
               FROM employees
               )
ORDER BY salary ASC;