with
employees
as
(
select 1 as EmployeeID, 1 as DepartmentID, 16858 as Salary, 0 as IsDirector, '1985-01-01' as DateOfBirth union all
select 2,1,18794,1,'1985-03-01' union all
select 3,1,17257,0,'1985-01-12' union all
select 4,1,17654,0,'1988-05-02' union all
select 5,1,16262,0,'1992-06-09' union all
select 6,2,16650,0,'1986-02-15' union all
select 7,2,15211,0,'1987-03-18' union all
select 8,2,16117,0,'1995-11-20' union all
select 9,2,16958,0,'1994-10-14' union all
select 10,2,16495,0,'1997-12-17' union all
select 11,2,17629,1,'1989-08-15' union all
select 12,3,17352,0,'1989-09-12' union all
select 13,3,16692,0,'1986-08-05' union all
select 14,3,17154,0,'1992-11-14' union all
select 15,3,16128,0,'1991-03-19' union all
select 16,3,19094,1,'1988-04-17' union all
select 17,3,15208,0,'1993-04-20' union all
select 18,3,17091,0,'1996-08-21' union all
select 18,3,17091,0,'1996-08-21'
)
select *
from employees
Telegram: DB developers channel