Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Problem 1
- SELECT
- employees.employee_id,
- CONCAT(employees.first_name,
- ' ',
- employees.last_name) AS 'full_name',
- departments.department_id,
- departments.name
- FROM
- employees
- JOIN
- departments ON employees.employee_id = departments.manager_id
- ORDER BY employees.employee_id
- LIMIT 5;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement