数据库第五章课后题

6

CREATE TABLE DEPT
(Deptno NUMERIC(9) PRIMMARY KEY,
Dname CHAR(9),
Manage CHAR(10),
Phone CHAR(11);
CREATE TABLE Workers(
					Num CHAR(9) PRIMARY KEY,
					Name   CHAR(9) ,
					Age   SMALLINT CHECK (Age<=60),
					Job   CHAR(9),
					Pay   SMALLINT,
					Dnum CHAR(9),
					FOREIGN KEY(Dnum) REFERENCES DEPT(Deptno));

2

(1) 统计离散数学的成绩分布情况，即按照个分段统计人数。

CREATE TABLE Divide(
	Grade CHAR(20),
	Num INT
)
INSERT INTO Divide
VALUES('[0,20)',0),('[20,40)',0),('[40,60)',0),('[60,80)',0),('[80,100]',0);
SELECT * FROM Divide

EXEC Proc_Grade;
SELECT *FROM SC WHERE Cno=8
SELECT *FROM Divide
<