Maque a conculta que recupera o nome de todos os departamentos e, caso exista, o nome e sobrenome do gerente.

Question

Accepted Answer

SELECT d.Dname, 
        concat(e.Fname, ' ', e.Lname) full_name 
 FROM department d 
 LEFT JOIN employee e ON e.Ssn = d.Mgr_ssn 
 ORDER BY 1, 2;

Answer

SELECT d.Dname, 
        concat(e.Fname, ' ', e.Lname) full_name 
 FROM department d 
 INNER JOIN employee e ON e.Dno = d.Dnumber 
 ORDER BY 1, 2;

Answer

SELECT d.Dname, 
        concat(e.Fname, ' ', e.Lname) full_name 
 FROM department d 
 RIGHT JOIN employee e ON e.Dno = d.Dnumber 
 ORDER BY 1, 2;

Answer

SELECT d.Dname, 
        concat(e.Fname, ' ', e.Lname) full_name 
 FROM department d 
 LEFT JOIN employee e ON e.Dno = d.Dnumber 
 ORDER BY 1, 2;

Answer

SELECT d.Dname, 
        concat(e.Fname, ' ', e.Lname) full_name 
 FROM department d 
 INNER JOIN employee e ON e.Ssn = d.Mgr_ssn 
 ORDER BY 1, 2;

Crowdly