Marque a consulta que recupera o nome dos dependentes filhos(as) do colaborador Franklin Wong.

Question

Answer

SELECT d.Dependent_name 
 FROM dependent AS d 
 JOIN employee AS e USING (Ssn) 
 WHERE e.Fname = 'Franklin' 
       AND e.Lname = 'Wong' 
       AND d.Relationship IN ('Daughter','Son') 
 ORDER BY d.Dependent_name;

Answer

SELECT d.Dependent_name 
 FROM dependent AS d, employee AS e 
 WHERE e.Fname = 'Franklin' 
       AND e.Lname = 'Wong' 
       AND d.Relationship IN ('Daughter','Son') 
 ORDER BY d.Dependent_name;

Answer

SELECT d.Dependent_name 
 FROM dependent AS d 
 INNER JOIN employee AS e ON e.Ssn = d.Essn 
 WHERE e.Fname = 'Franklin' 
       AND e.Lname = 'Wong' 
 ORDER BY d.Dependent_name;

Answer

SELECT d.Dependent_name 
 FROM dependent AS d 
 INNER JOIN employee AS e ON e.Ssn = d.Essn 
 WHERE e.Fname = 'Franklin' 
       AND e.Lname = 'Wong' 
       AND d.Relationship IN ('Daughter','Son') 
 ORDER BY d.Dependent_name;

Answer

SELECT d.Dependent_name 
 FROM dependent AS d 
 WHERE d.Dependent_name = 'Franklin Wong' 
       AND d.Relationship IN ('Daughter','Son') 
 ORDER BY d.Dependent_name;

Crowdly

Marque a consulta que recupera o nome dos dependentes filhos(as) do colaborador ...

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