Marque a consulta que recupera os pares de colaboradores que possuem o mesmo nome (homônimos) e números diferentes de Ssn.

Question

Answer

SELECT concat(e1.Fname, ' ', e1.Minit, ' ', e1.Lname) full_name_1, 
        e1.Ssn, 
        e2.Ssn 
 FROM employee AS e1 
 INNER JOIN employee AS e2 ON e1.Ssn = e2.Ssn 
  AND e1.Fname = e2.Fname 
       AND e1.Minit = e2.Minit 
       AND e1.Lname = e2.Lname  
 ORDER BY 1;

Answer

SELECT concat(e1.Fname, ' ', e1.Minit, ' ', e1.Lname) full_name_1, 
        e1.Ssn, 
        e2.Ssn 
 FROM employee AS e1, employee AS e2 
 WHERE e1.Fname = e2.Fname 
       AND e1.Minit = e2.Minit 
       AND e1.Lname = e2.Lname 
       AND e1.Ssn <> e2.Ssn 
 GROUP BY 1;

Answer

SELECT concat(e1.Fname, ' ', e1.Minit, ' ', e1.Lname) full_name_1, 
        e1.Ssn, 
        e2.Ssn 
 FROM employee AS e1, employee AS e2 
 WHERE e1.Fname = e2.Fname 
       AND e1.Minit = e2.Minit 
       AND e1.Lname = e2.Lname  
       AND e1.Ssn <> e2.Ssn 
 GROUP BY 1;

Answer

SELECT concat(e1.Fname, ' ', e1.Minit, ' ', e1.Lname) full_name_1, 
        e1.Ssn, 
        e2.Ssn 
 FROM employee AS e1 
 NATURAL JOIN employee AS e2 
 WHERE e1.Ssn <> e2.Ssn 
 ORDER BY 1;

Answer

SELECT concat(e1.Fname, ' ', e1.Minit, ' ', e1.Lname) full_name_1, 
        e1.Ssn, 
        e2.Ssn 
 FROM employee AS e1 
 INNER JOIN employee AS e2 ON e1.Ssn <> e2.Ssn 
 WHERE e1.Fname = e2.Fname 
       AND e1.Minit = e2.Minit 
       AND e1.Lname = e2.Lname  
 ORDER BY 1;

Crowdly

Marque a consulta que recupera os pares de colaboradores que possuem o mesmo nom...

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