CREATE TABLE emp (
	id INT PRIMARY KEY AUTO_INCREMENT,
	name VARCHAR(20),
	age INT,
	enterdate DATE,
	dept_id INT,
	manager_id INT,
	job VARCHAR(20),
	salary INT
) comment '员工表';

INSERT INTO emp values (1, '赵', 90, '2020-01-01', 1, 8, '保安', 1000);
INSERT INTO emp values (2, '钱', 60, '2020-01-01', 1, 8, '保安', 6000);
INSERT INTO emp values (3, '孙', 33, '2021-01-01', 2, 8, '前端', 11000);
INSERT INTO emp values (4, '李', 19, '2000-01-01', 2, 8, '后端', 23000);
INSERT INTO emp values (5, '周', 44, '2023-01-01', 3, 8, '财务', 26000);
INSERT INTO emp values (6, '吴', 80, '2020-01-01', 3, 8, '财务', 16000);
INSERT INTO emp values (7, '郑', 18, '2010-01-01', 4, 8, '销售', 7000);
INSERT INTO emp values (8, '王', 55, '2020-01-01', 4, 8, '销售', 10000);

CREATE TABLE dept (
	id int,
	name VARCHAR(20),
);

INSERT INTO dept values (1, '安保部');
INSERT INTO dept values (2, '技术部');
INSERT INTO dept values (3, '财务部');
INSERT INTO dept values (4, '销售部');
INSERT INTO dept values (5, '总经部');

create table salgrade (
  grade int,
	losal int,
	hisal int,
) comment '薪资等级表';

insert into salgrade values (1,0,3000);
insert into salgrade values (2,3001,5000);
insert into salgrade values (3,5001,8000);
insert into salgrade values (4,8001,10000);
insert into salgrade values (5,10001,15000);
insert into salgrade values (6,15001,20000);
insert into salgrade values (7,20001,25000);
insert into salgrade values (8,25001,30000);