Marque a consulta que projeta o nome e salário atual dos colaboradores, bem como uma projeção de 10% de aumento no salário daqueles que trabalham no projeto 'Computerization'. Para os colaboradores que trabalham nos demais projetos ou não estão alocados em nenhum projeto, projetar um aumento de 5%.

Question

Accepted Answer

SELECT  concat(e.Fname, ' ', e.Minit , ' ', e.Lname) full_name, 
         e.salary, 
         CASE p.Pname 
           WHEN 'Computerization' THEN e.salary + (e.salary * .10) 
           ELSE e.salary + (e.salary * .05) 
         END new_salary 
 FROM employee e 
 LEFT JOIN works_on w ON w.Essn = e.Ssn 
 LEFT JOIN project p ON p.Pnumber = w.Pno 
 ORDER BY p.Pname, e.Lname, e.Fname;

Answer

SELECT  concat(e.Fname, ' ', e.Minit , ' ', e.Lname) full_name, 
         e.salary, 
         CASE p.Pname 
           WHEN 'Computerization' THEN e.salary + (e.salary * .10) 
           ELSE e.salary + (e.salary * .05) 
         END new_salary 
 FROM employee e, works_on w, project p 
 ON w.Essn = e.Ssn 
 ON p.Pnumber = w.Pno 
 ORDER BY p.Pname, e.Lname, e.Fname;

Answer

SELECT  concat(e.Fname, ' ', e.Minit , ' ', e.Lname) full_name, 
         e.salary, 
         CASE p.Pname 
           WHEN 'Computerization' THEN e.salary + (e.salary * .10) 
           ELSE e.salary + (e.salary * .05) 
         END new_salary 
 FROM employee e 
 INNER JOIN works_on w ON w.Essn = e.Ssn 
 INNER JOIN project p ON p.Pnumber = w.Pno 
 ORDER BY p.Pname, e.Lname, e.Fname;

Answer

SELECT  concat(e.Fname, ' ', e.Minit , ' ', e.Lname) full_name, 
         e.salary, 
         CASE 
           WHEN p.Pname = 'Computerization' THEN e.salary + (e.salary * .10) 
           ELSE e.salary + (e.salary * .05) 
         END new_salary 
 FROM employee e 
 NATURAL JOIN works_on w  
 NATURAL JOIN project p 
 ORDER BY p.Pname, e.Lname, e.Fname;

Answer

SELECT  concat(e.Fname, ' ', e.Minit , ' ', e.Lname) full_name, 
         e.salary, 
         CASE p.Pname 
           WHEN 'Computerization' THEN e.salary + (e.salary * .10) 
           ELSE e.salary + (e.salary * .05) 
         END new_salary 
 FROM employee e 
 NATURAL JOIN works_on w 
 LEFT JOIN project p ON p.Pnumber = w.Pno 
 ORDER BY p.Pname, e.Lname, e.Fname;

Crowdly

Marque a consulta que projeta o nome e salário atual dos colaboradores, bem como...

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