Marque a consulta que projeta/recupera o nome completo de todos os colaboradores que trabalham no departamento 'Research'.

Question

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e  
 NATURAL JOIN department d 
 WHERE d.Dname LIKE 'Research';

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e  
 INNER JOIN department d ON d.Dnumber = e.Dno 
 WHERE d.Dname LIKE 'Research';

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e  
 JOIN department d USING (Dno) 
 WHERE d.Dname LIKE 'Research';

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e  
 JOIN department d USING (Dno) 
 WHERE d.Dname IS 'Research';

Answer

SELECT  concat(e.Fname, ' ', e.Minit, ' ', e.Lname) full_name 
 FROM employee e  
 INNER JOIN department d ON d.Dnumber = e.Dno 
 WHERE d.Dname IS 'Research';

Crowdly

Marque a consulta que projeta/recupera o nome completo de todos os colaboradores...

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