Marque a consulta que recupera os colaboradores que residem no mesmo endereço que seu gerente.

Question

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e 
 INNER JOIN employee m ON m.Address = e.Address;

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e 
 INNER JOIN employee m ON m.Super_ssn = e.Super_ssn 
 WHERE e.Address = m.Address;

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e 
 INNER JOIN employee m ON m.Ssn = e.Super_ssn 
 WHERE e.Address = m.Address;

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e  
 INNER JOIN employee m ON m.Ssn = e.Ssn 
 WHERE e.Address = m.Address;

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e 
 INNER JOIN employee m ON m.Ssn != e.Super_ssn 
 WHERE e.Address = m.Address;

Crowdly

Marque a consulta que recupera os colaboradores que residem no mesmo endereço qu...

Want instant access to all verified answers on moodle.utfpr.edu.br?