I'm a beginner and stuck with this query.
Write a query in SQL to display the first name, last name, and department number for those employees who works in the same department as the employee who holds the last name as Taylor.
can someone kindly help me with this.
JOIN employees e1 ON e.department_id = e1.department_id
e1.last_name LIKE 'Taylor'
This is my query and not getting the required output.