MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Create table Departments (DepartmentID int primary key, Name text);

insert into Departments values
(1001,'SRO'),
(2001,'Drs'),
(3001,'Accounting');

Create table Employees 
(
  EmployeeID int not null, 
  DepartmentID int not null,
  ManagerID int,
  Name varchar(50) not null,
  Salary int not null,
  primary key(EmployeeID),
  foreign key (DepartmentID)
    references Departments(DepartmentID)
 );

insert into Employees values
(68319,1001,NULL,'Kayling','6000.00'),
(66928,3001,68319,'Blaze','2750.00'),
(67832,1001,68319,'Clare','2550.00'),
(65646,2001,68319,'Jonas','2957.00'),
(67858,2001,65646,'Scarlet','3100.00'),
(69062,2001,65646,'Frank','3100.00'),
(63679,2001,69062,'Sandrine','900.00'),
(64989,3001,66928,'Adelyn','1700.00'),
(65271,3001,66928,'Wade','1350.00');

Records: 3  Duplicates: 0  Warnings: 0



Records: 9  Duplicates: 0  Warnings: 0


select * from Employees order by Employeeid;


EmployeeID
DepartmentID
ManagerID
Name
Salary


63679
2001
69062
Sandrine
900

64989
3001
66928
Adelyn
1700

65271
3001
66928
Wade
1350

65646
2001
68319
Jonas
2957

66928
3001
68319
Blaze
2750

67832
1001
68319
Clare
2550

67858
2001
65646
Scarlet
3100

68319
1001
null
Kayling
6000

69062
2001
65646
Frank
3100


select e1.*, e2.*
from Employees e1 
left join Employees e2 on e1.ManagerID = e2.EmployeeID
order by e1.employeeid;


EmployeeID
DepartmentID
ManagerID
Name
Salary
EmployeeID
DepartmentID
ManagerID
Name
Salary


63679
2001
69062
Sandrine
900
69062
2001
65646
Frank
3100

64989
3001
66928
Adelyn
1700
66928
3001
68319
Blaze
2750

65271
3001
66928
Wade
1350
66928
3001
68319
Blaze
2750

65646
2001
68319
Jonas
2957
68319
1001
null
Kayling
6000

66928
3001
68319
Blaze
2750
68319
1001
null
Kayling
6000

67832
1001
68319
Clare
2550
68319
1001
null
Kayling
6000

67858
2001
65646
Scarlet
3100
65646
2001
68319
Jonas
2957

68319
1001
null
Kayling
6000
null
null
null
null
null

69062
2001
65646
Frank
3100
65646
2001
68319
Jonas
2957

EmployeeID	DepartmentID	ManagerID	Name	Salary
63679	2001	69062	Sandrine	900
64989	3001	66928	Adelyn	1700
65271	3001	66928	Wade	1350
65646	2001	68319	Jonas	2957
66928	3001	68319	Blaze	2750
67832	1001	68319	Clare	2550
67858	2001	65646	Scarlet	3100
68319	1001	null	Kayling	6000
69062	2001	65646	Frank	3100