第五章课后习题

第五章课后习题

CREATE TABLE ZHIGONG
       (Sno   CHAR(9)  PRIMARY KEY,--主码
        Sname CHAR(20),     
        Ssex  CHAR(2),
        Sage  INT(2),
        CHECK(Sage<=60),
        ZHIWU  CHAR(20),
        SALARY   CHAR(20),
        BRANCH  CHAR(9),
        FOREIGN KEY (BRANCH) REFERENCES Dept(BRANCH)
       );
CREATE TABLE BUMEN
       (DNO9)  PRIMARY KEY,
        DNAME CHAR(20),     
        JNAME CHAR(20),
        TNUMBER   CHAR(20)
       );

`

```csharp
CREATE TABLE Amount (
	ScoreLevel CHAR(15),
	Number INT
)
INSERT
INTO Amount
VALUES ('小于60', 0), ('[60,70)', 0), ('[70,80)', 0),
       ('[80,90)', 0), ('大于等于90', 0);
SELECT * FROM Amount;

SELECT AVG(GRADE)
FROM SC
GROUP BY SNO;