MySQL（四）项目实战

这是本次课程的最后一次作业了。

作业七
题目：

code：

	--创建表
	CREATE TABLE Employee(
	Id INT NOT NULL PRIMARY KEY,
	Name VARCHAR(50) NOT NULL,
	Salary INT NOT NULL,
	Departmentld INT
	);

	INSERT INTO Employee (Id,Name,Salary,Departmentld) 
	VALUES (1,'Joe',70000,1),
				(2,'Herry',80000,2),
				(3,'Sam',60000,2),
				(4,'Max',90000,1);
				
	CREATE TABLE Department(
		Id INT NOT NULL PRIMARY KEY,
		Name VARCHAR(50) NOT NULL);
		
	INSERT INTO Department VALUES
		(1,'IT'),
		(2,'Sales');

	SELECT D.name AS department,E.name,E.salary
	FROM Employee AS E 
	JOIN Department AS D
	ON E.department_id = D.id
	WHERE salary IN(
	SELECT MAX(salary)
	FROM Employee
	GROUP BY department_id);

作业八
题目：