Considere o modelo de dados relacionais HR ( Human Resources ).
Marque a alternativa que apresenta a consulta SQL que recupera o nome de todos os departamentos e, quando houver, o nome de seus respectivos gerentes.

Question

Considere o modelo de dados relacionais HR ( Human Resources ).  
 Marque a alternativa que apresenta a consulta SQL que recupera o nome de todos os departamentos e, quando houver, o nome de seus respectivos gerentes.

Accepted Answer

SELECT d.department_name departmento, 
         CONCAT(g.first_name, ' ', g.last_name) gerente 
 FROM departments d 
 LEFT JOIN employees g ON g.employee_id = d.manager_id 
 ORDER BY 1;

Answer

SELECT d.department_name departmento, 
         CONCAT(g.first_name, ' ', g.last_name) gerente 
 FROM departments d 
 RIGHT JOIN employees g ON g.employee_id = d.manager_id 
 ORDER BY 1;

Answer

SELECT d.department_name departmento, 
         CONCAT(g.first_name, ' ', g.last_name) gerente 
 FROM departments d 
 JOIN employees g USING (employee_id) 
 ORDER BY 1;

Answer

SELECT d.department_name departmento, 
         CONCAT(g.first_name, ' ', g.last_name) gerente 
 FROM departments d 
 FULL JOIN employees g ON g.employee_id = d.manager_id 
 ORDER BY 1;

Answer

SELECT d.department_name departmento, 
         CONCAT(g.first_name, ' ', g.last_name) gerente 
 FROM departments d 
 NATURAL JOIN employees g 
 ORDER BY 1;

Crowdly

Considere o modelo de dados relacionais HR ( Human Resources ). Marque a alte...

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