TT1 4 Query SQL

[vanderleipinto]

4

A partir das tabelas do banco de dados abaixo, escreva uma query sql que através de join, retorne o nome completo, cpf, equipe e cargo dos colaboradores ordenando os por cpf.

Tabela employees	first_name	last_name	cpf	team_id	job_title_id
Pedro	Alves	665.415.876-80	2	3	Cell
Tiago	Nogueira	032.336.130-75	1	1	Cell
João	Neves	461.636.517-23	1	2	Cell

Tabela teams	id	name
1	Ti
2	Suporte
3	Financeiro

Tabela job_titles

id	name
1	Desenvolvedor back-endimpr
2	Desenvolvedor front-end
3	Encantador de clientes

Resposta:

SELECT CONCAT(employees.first_name,' ', employees.last_name) AS full_name,
cpf, teams.name AS equipe,
job_titles.name AS cargo FROM employees
JOIN teams ON employees.team_id = teams.id
JOIN job_titles ON employees.job_title_id = job_titles.id
ORDER BY CPF;

[vanderleipinto]

4

Resposta:

SELECT CONCAT(employees.first_name,' ', employees.last_name) AS full_name,
cpf, teams.name AS equipe,
job_titles.name AS cargo FROM employees
JOIN teams ON employees.team_id = teams.id
JOIN job_titles ON employees.job_title_id = job_titles.id
ORDER BY CPF;