CREATE DATABASE Proverka
 
USE Proverka
GO
 
IF OBJECT_ID('employes') IS NULL
CREATE TABLE employes(
ID INT IDENTITY (1,1) PRIMARY KEY ,
Code VARCHAR(50) NOT NULL UNIQUE,
Post VARCHAR(50) NOT NULL,
Name VARCHAR(255) NOT NULL,
DateBegin DATE NOT NULL,
DateEnd DATE NULL,
ID_Parent VARCHAR(50) NULL
);
GO 
 
INSERT employes VALUES 
('0001','General director','Иванов','20000101', NULL, NULL),
('0002','The leader of team 1','Петров','20000101', NULL, 0001),
('0003','The leader of team 2','Сидоров','20000101', NULL, 0001),
('0004','Employe 1','Клюшкина','20000101', NULL, 0002),
('0005','Employe 2','Мишустина','20000101', NULL, 0002),
('0006','Employe 3','Котельников','20000101', NULL, 0002),
('0007','Employe 4','Сидельникова','20000101', NULL, 0003),
('0008','Employe 5','Мокрушин','20000101', '20200502', 0003),
('0009','Employe 6','Маленькая','20000101', NULL, 0003),
('00010','Employe 7','Большой','20000101', '20210315', 0009),
('00011','Employe 8','Иванов','20000101', NULL, 0009),
('00012','Employe 9','Сидоров','20000101', NULL, 00011);
 
 
SELECT * FROM employes
WHERE (ID_Parent = 3) AND DateEnd IS NULL