What are the full names and hire dates for employees in the same department as someone with the first name 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 first_name  =  "Clara")
[{'FIRST_NAME': 'John', 'LAST_NAME': 'Russell', 'HIRE_DATE': '1987-08-01'}, {'FIRST_NAME': 'Karen', 'LAST_NAME': 'Partners', 'HIRE_DATE': '1987-08-02'}, {'FIRST_NAME': 'Alberto', 'LAST_NAME': 'Errazuriz', 'HIRE_DATE': '1987-08-03'}, {'FIRST_NAME': 'Gerald', 'LAST_NAME': 'Cambrault', 'HIRE_DATE': '1987-08-04'}, {'FIRST_NAME': 'Eleni', 'LAST_NAME': 'Zlotkey', 'HIRE_DATE': '1987-08-05'}, {'FIRST_NAME': 'Peter', 'LAST_NAME': 'Tucker', 'HIRE_DATE': '1987-08-06'}, {'FIRST_NAME': 'David', 'LAST_NAME': 'Bernstein', 'HIRE_DATE': '1987-08-07'}, {'FIRST_NAME': 'Peter', 'LAST_NAME': 'Hall', 'HIRE_DATE': '1987-08-08'}, {'FIRST_NAME': 'Christopher', 'LAST_NAME': 'Olsen', 'HIRE_DATE': '1987-08-09'}, {'FIRST_NAME': 'Nanette', 'LAST_NAME': 'Cambrault', 'HIRE_DATE': '1987-08-10'}, {'FIRST_NAME': 'Oliver', 'LAST_NAME': 'Tuvault', 'HIRE_DATE': '1987-08-11'}, {'FIRST_NAME': 'Janette', 'LAST_NAME': 'King', 'HIRE_DATE': '1987-08-12'}, {'FIRST_NAME': 'Patrick', 'LAST_NAME': 'Sully', 'HIRE_DATE': '1987-08-13'}, {'FIRST_NAME': 'Allan', 'LAST_NAME': 'McEwen', 'HIRE_DATE': '1987-08-14'}, {'FIRST_NAME': 'Lindsey', 'LAST_NAME': 'Smith', 'HIRE_DATE': '1987-08-15'}, {'FIRST_NAME': 'Louise', 'LAST_NAME': 'Doran', 'HIRE_DATE': '1987-08-16'}, {'FIRST_NAME': 'Sarath', 'LAST_NAME': 'Sewall', 'HIRE_DATE': '1987-08-17'}, {'FIRST_NAME': 'Clara', 'LAST_NAME': 'Vishney', 'HIRE_DATE': '1987-08-18'}, {'FIRST_NAME': 'Danielle', 'LAST_NAME': 'Greene', 'HIRE_DATE': '1987-08-19'}, {'FIRST_NAME': 'Mattea', 'LAST_NAME': 'Marvins', 'HIRE_DATE': '1987-08-20'}, {'FIRST_NAME': 'David', 'LAST_NAME': 'Lee', 'HIRE_DATE': '1987-08-21'}, {'FIRST_NAME': 'Sundar', 'LAST_NAME': 'Ande', 'HIRE_DATE': '1987-08-22'}, {'FIRST_NAME': 'Amit', 'LAST_NAME': 'Banda', 'HIRE_DATE': '1987-08-23'}, {'FIRST_NAME': 'Lisa', 'LAST_NAME': 'Ozer', 'HIRE_DATE': '1987-08-24'}, {'FIRST_NAME': 'Harrison', 'LAST_NAME': 'Bloom', 'HIRE_DATE': '1987-08-25'}, {'FIRST_NAME': 'Tayler', 'LAST_NAME': 'Fox', 'HIRE_DATE': '1987-08-26'}, {'FIRST_NAME': 'William', 'LAST_NAME': 'Smith', 'HIRE_DATE': '1987-08-27'}, {'FIRST_NAME': 'Elizabeth', 'LAST_NAME': 'Bates', 'HIRE_DATE': '1987-08-28'}, {'FIRST_NAME': 'Sundita', 'LAST_NAME': 'Kumar', 'HIRE_DATE': '1987-08-29'}, {'FIRST_NAME': 'Ellen', 'LAST_NAME': 'Abel', 'HIRE_DATE': '1987-08-30'}, {'FIRST_NAME': 'Alyssa', 'LAST_NAME': 'Hutton', 'HIRE_DATE': '1987-08-31'}, {'FIRST_NAME': 'Jonathon', 'LAST_NAME': 'Taylor', 'HIRE_DATE': '1987-09-01'}, {'FIRST_NAME': 'Jack', 'LAST_NAME': 'Livingston', 'HIRE_DATE': '1987-09-02'}, {'FIRST_NAME': 'Charles', 'LAST_NAME': 'Johnson', 'HIRE_DATE': '1987-09-04'}]