练习题综合打卡

#练习一: 各部门工资最高的员工（难度：中等）
#创建Employee 表，包含所有员工信息，每个员工有其对应的 Id, salary 和 department Id。
CREATE TABLE Employee
(Employee_id CHAR(4) NOT NULL ,
Name VARIANCE(100),
Employee_salary VARCHAR(100),
Employee_department varchar(100),
PRIMARY key(Employee_id));

ALTER TABLE Employee MODIFY Employee_id char(4) NOT NULL AUTO_INCREMENT;

INSERT INTO Employee(Name,Employee_salary,Employee_department)VALUES(‘Joe’,70000,1);
INSERT INTO Employee(Name,Employee_salary,Employee_department)VALUES(‘Henry’,80000,2);
INSERT INTO Employee(Name,Employee_salary,Employee_department)VALUES(‘Sam’,60000,2);
INSERT INTO Employee(Name,Employee_salary,Employee_department)VALUES(‘Max’,90000,1);