Marque a consulta que recupera a lista dos colaboradores e de seus projetos, ordenado de forma crescente por departamento do colaborador e, dentro de cada departamento, ordenado alfabeticamente pelo último nome e primeiro nome do colaborador.

Question

Accepted Answer

SELECT d.Dname, e.Lname, e.Fname, p.Pname 
 FROM department AS d, employee AS e, works_on AS w, project AS p 
 WHERE   d.Dnumber = e.Dno 
         AND e.Ssn = w.Essn 
         AND w.Pno = p.Pnumber 
 ORDER BY d.Dname, e.Lname, e.Fname;

Answer

SELECT d.Dname, e.Lname, e.Fname, p.Pname 
 FROM department AS d, employee AS e, works_on AS w, project AS p 
 WHERE   d.Dnumber = p.Dnum 
         AND e.Ssn = w.Essn 
         AND w.Pno = p.Pnumber 
 ORDER BY d.Dname, e.Lname, e.Fname;

Answer

SELECT d.Dname, e.Lname, e.Fname, p.Pname 
 FROM employee AS e, department AS d, works_on AS w, project AS p 
 WHERE   d.Dnumber = e.Dno 
         AND e.Ssn = w.Essn 
 ORDER BY d.Dname, e.Lname, e.Fname;

Answer

SELECT d.Dname, e.Lname, e.Fname, p.Pname 
 FROM department AS d, employee AS e, works_on AS w, project AS p 
 WHERE   d.Dnumber = e.Dno 
         AND e.Ssn = w.Essn 
         AND w.Pno = p.Pnumber 
 ORDER BY d.Dname DESC, e.Lname DESC, e.Fname DESC;

Answer

SELECT d.Dname, e.Lname, e.Fname, p.Pname 
 FROM department AS d, employee AS e, works_on AS w, project AS p 
 WHERE   d.Dnumber = e.Dno 
         AND e.Ssn = w.Essn 
 ORDER BY d.Dname, e.Lname, e.Fname;

Crowdly

Marque a consulta que recupera a lista dos colaboradores e de seus projetos, ord...

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