Vânia Vidal Brasil
Show the CPF, employees (empregados) name and department (departamentos) name of the employees that don't work (trabalha) in any project (projetos). The result must be order by CPF.
Column | Type |
cpf (PK) | varchar (15) |
enome | varchar (60) |
salario | float |
cpf_supervisor | varchar (15) |
dnumero | integer) |
Column | Type |
dnumero (PK) | integer |
dnome | varchar (60) |
cpf_gerente (FK) | varchar (15) |
Column | Type |
cpf_emp (FK) | varchar (15) |
pnumero | integer |
Column | Type |
pnumero (PK) | integer |
pnome | varchar (45) |
dnumero (FK) | integer |
cpf | enome | salario | cpf_supervisor | dnumero |
049382234322 | João Silva | 2350 | 2434332222 | 1010 |
586733922290 | Mario Silveira | 3500 | 2434332222 | 1010 |
2434332222 | Aline Barros | 2350 | (null) | 1010 |
1733332162 | Tulio Vidal | 8350 | (null) | 1020 |
4244435272 | Juliana Rodrigues | 3310 | (null) | 1020 |
1014332672 | Natalia Marques | 2900 | (null) | 1010 |
dnumero | dnome | cpf_gerente |
1010 | Pesquisa | 049382234322 |
1020 | Ensino | 2434332222 |
cpf_emp | pnumero |
49382234322 | 2010 |
586733922290 | 2020 |
49382234322 | 2020 |
pnumero | pnome | dnumero |
2010 | Alpha | 1010 |
2020 | Beta | 1020 |
cpf | enome | dnome |
1014332672 | Natalia Marques | Pesquisa |
1733332162 | Tulio Vidal | Ensino |
2434332222 | Aline Barros | Pesquisa |
4244435272 | Juliana Rodrigues | Ensino |