Question

Suppose the company recently hired 5 new employees. You and another person are assigned to IT support department. Another new employee is assigned to IT help desk. The remaining 2 new employees are assigned to Marketing department. Including yourself, add the 5 new employees in the Employees table. Don’t just add meaningless records, using ‘INSERT’ query. The information should look real.

Answer 1

EMPLOYEE TABLE

insert into employee values(4001,'John','System analyst',9001,'25-Mar-2020',23000,'IT SUPPORT');
insert into employee values(4002,'Peter','System Manager',9001,'20-Mar-2020',53000,'IT SUPPORT');

insert into employee values(4003,'Parker','Technician',90098,'20-Jan-2019',33000,'IT HELP DESK');

insert into employee values(4004,'David','Brand Manager',9007,'17-Dec-2018',83000,'IT MARKETING');
insert into employee values(4005,'Dueno','Content Marketing',9007,'13-Dec-2018',73000,'IT MARKETING');

DON'T FORGET TO LIKE.

THANKS BY HEART.