What is their average salary?
SELECT  avg ( SALARY )  FROM employees WHERE department_id   =    ( SELECT department_id FROM employees WHERE first_name   =   "Clara" ) 
average salary refers to AVG(SALARY); their refers to employees in the same department as a specific employee; department of a specific employee is identified by department_id of an employee with first_name = 'Clara';