Advertisement
AngelKejov

Untitled

Jan 28th, 2022
1,366
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.34 KB | None | 0 0
  1. -- Problem 1
  2. SELECT
  3.     employees.employee_id,
  4.     CONCAT(employees.first_name,
  5.             ' ',
  6.             employees.last_name) AS 'full_name',
  7.     departments.department_id,
  8.     departments.name
  9. FROM
  10.     employees
  11.         JOIN
  12.     departments ON employees.employee_id = departments.manager_id
  13. ORDER BY employees.employee_id
  14. LIMIT 5;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement