Write a query which displays the full name and department id of employees who work in...

 

Transcribed Image Text:

Write a query which displays the full name and department id of employees who work in the same department as anyone whose last name starts with 'M' Do not display anyone whose last name starts with 'M' Employee Trenna Rajs Curtis Davies Peter Vargas department_id 50 50 50 Write a query which displays the full name and department id of employees who work in the same department as anyone whose last name starts with 'M' Do not display anyone whose last name starts with 'M' Employee Trenna Rajs Curtis Davies Peter Vargas department_id 50 50 50