Marque a consulta que recupera o código e nome completo dos colaboradores que não possuem gerente e recebem salário entre R$ 40.000,00 e R$ 60.000,00.

Question

Answer

SELECT  Ssn, 
         concat(Fname, ' ', Minit, ' ', Lname) full_name 
 FROM employee 
 WHERE Super_ssn IS NULL  
       AND Salary >= 40000 AND <= 60000;

Answer

SELECT  Ssn, 
         concat(Fname, ' ', Minit, ' ', Lname) full_name 
 FROM employee 
 WHERE Salary >= 40000  
       AND Salary <= 60000;

Answer

SELECT  Ssn, 
         concat(Fname, ' ', Minit, ' ', Lname) full_name 
 FROM employee 
 WHERE Super_ssn IS NULL  
       AND Salary BETWEEN 40000 AND 60000;

Answer

SELECT  Ssn, 
         Fname | ' ' | Minit | ' ' | Lname AS full_name 
 FROM employee 
 WHERE Super_ssn IS NULL 
       AND Salary >= 40000  
       AND Salary <= 60000;

Crowdly

Marque a consulta que recupera o código e nome completo dos colaboradores que nã...

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