What are the full names and hire dates for employees in the same department as someone with the first name Clara, not including Clara?
SELECT first_name ,  last_name ,  hire_date FROM employees WHERE department_id  =  ( SELECT department_id FROM employees WHERE first_name  =  "Clara") AND first_name != "Clara"
employees in the same department as someone with the first name Clara refers to matching department_id where first_name = 'Clara'; excluding Clara refers to first_name != 'Clara'; full names refers to concatenation of first_name and last_name or selecting both columns; hire dates refers to hire_date;