Can you show me their hire dates?
select hire_date from employees where department_id = ( select department_id from employees where first_name = "Clara" )
What is their average salary?
select avg ( salary ) from employees where department_id = ( select department_id from employees where first_name = "Clara" )