Task: Text to Code
Input (English): SQL: SELECT EMPLOYEE_ID , LAST_NAME FROM employees WHERE FIRST_NAME LIKE "T"
Feedback: Also find first name ahead of last name , employee should have another employee containing letter T in ( same)department
Output (English): SELECT employee_id ,  first_name ,  last_name FROM employees WHERE department_id IN ( SELECT department_id FROM employees WHERE first_name LIKE '%T%' )