CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, hire_date VARCHAR, department_id VARCHAR)

display the employee name ( first name and last name ) and hire date for all employees in the same department as Clara.
SELECT first_name, last_name, hire_date FROM employees WHERE department_id = (SELECT department_id FROM employees WHERE first_name = "Clara")
SELECT "first_name", "last_name", "hire_date" FROM "employees" WHERE "department_id" = (SELECT "department_id" FROM "employees" WHERE "Clara" = "first_name")