use newdb;
create table employeedetails(
	emp_id VARCHAR(20),
    emp_name VARCHAR(50) NOT NULL,
    emp_age INT NOT NULL,
    emp_function VARCHAR(50) NOT NULL,
    PRIMARY KEY(emp_id)
);
select * from employeedetails;

insert into employeedetails(emp_id,emp_name,emp_age,emp_function)
values("EMP123", "PETER", 25, "MARKETING");

DELETE FROM employeedetails;

INSERT INTO employeedetails VALUES
('EMP566','Liam',34,'Marketing'),
('EMP567','Noah',29,'Service Delivery'),
('EMP568','Oliver',23,'Human Resources'),
('EMP569','Elijah',35,'Information Technolgy'),
('EMP570','William',25,'Finance'),
('EMP571','James',34,'Commercial'),
('EMP572','Benjamin',34,'Sales'),
('EMP573','Lucas',38,'Helpdesk'),
('EMP574','Henry',38,'Marketing'),
('EMP575','Alexander',35,'Service Delivery'),
('EMP576','Mason',33,'Human Resources'),
('EMP577','Michael',34,'Information Technolgy'),
('EMP578','Ethan',29,'Finance'),
('EMP579','Daniel',31,'Commercial'),
('EMP580','Jacob',19,'Sales'),
('EMP581','Logan',32,'Helpdesk'),
('EMP582','Jackson',27,'Marketing'),
('EMP583','Levi',30,'Service Delivery'),
('EMP584','Sebastian',20,'Human Resources'),
('EMP585','Mateo',19,'Information Technolgy'),
('EMP586','Jack',23,'Finance'),
('EMP587','Owen',32,'Commercial'),
('EMP588','Theodore',38,'Sales'),
('EMP589','Aiden',28,'Helpdesk'),
('EMP590','Samuel',35,'Marketing'),
('EMP591','Joseph',22,'Service Delivery'),
('EMP592','John',24,'Human Resources'),
('EMP593','David',34,'Information Technolgy'),
('EMP594','Wyatt',29,'Finance'),
('EMP595','Matthew',24,'Commercial'),
('EMP596','Luke',38,'Sales'),
('EMP597','Asher',27,'Helpdesk'),
('EMP598','Carter',26,'Marketing'),
('EMP599','Julian',18,'Service Delivery'),
('EMP600','Grayson',28,'Human Resources'),
('EMP601','Leo',37,'Information Technolgy'),
('EMP602','Jayden',25,'Finance'),
('EMP603','Gabriel',31,'Commercial'),
('EMP604','Isaac',34,'Sales'),
('EMP605','Lincoln',21,'Helpdesk'),
('EMP606','Anthony',36,'Marketing'),
('EMP607','Hudson',20,'Service Delivery'),
('EMP608','Dylan',19,'Human Resources'),
('EMP609','Ezra',26,'Information Technolgy'),
('EMP610','Thomas',21,'Finance'),
('EMP611','Charles',28,'Commercial'),
('EMP612','Christopher',29,'Sales'),
('EMP613','Jaxon',19,'Helpdesk'),
('EMP614','Maverick',31,'Marketing'),
('EMP615','Josiah',26,'Service Delivery');