SCHEMA:
CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, hire_date VARCHAR, department_id VARCHAR)
USER:
display the employee name ( first name and last name ) and hire date for all employees in the same department as Clara.

QUERY:
SELECT first_name, last_name, hire_date FROM employees WHERE department_id = (SELECT department_id FROM employees WHERE first_name = "Clara")