vanderleipinto / TT1

0 stars 0 forks source link

TT4 #4

Open vanderleipinto opened 8 months ago

vanderleipinto commented 8 months ago

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;