sql建表

CREATE TABLE Student(
    Sno CHAR(10),
    Sname VARCHAR(20),
    Ssex CHAR(2),
    Sage SMALLINT,
    Sdept VARCHAR(20),
    PRIMARY KEY (Sno)
    );
    
CREATE TABLE Course(
    Cno CHAR(10),
    Cname VARCHAR(20),
    Cpno CHAR(10),
    Ccredit SMALLINT,
    PRIMARY KEY (Cno)
    );
	
CREATE TABLE SC(
    Sno CHAR(10),
    Cno CHAR(10),
    Grade SMALLINT,
    PRIMARY KEY (Cno,Sno)
    );
    
INSERT INTO Course VALUES(1,'数据库',5,4);
INSERT INTO Course VALUES(2,'数学',NULL,2);
INSERT INTO Course VALUES(3,'信息系统',1,4);
INSERT INTO Course VALUES(4,'操作系统',6,3);
INSERT INTO Course VALUES(5,'数据结构',7,4);
INSERT INTO Course VALUES(6,'数据处理',NULL,2);#数据处理系：ED
INSERT INTO Course VALUES(7,'PASCAL语言',6,4);#系PAL
INSERT INTO Course VALUES(8,'算法设计',5,4);#系AL
INSERT INTO Course VALUES(9,'JavaWeb',NULL,3);#系JW
INSERT INTO Course VALUES(10,'MyBatis设计',1,4);#系MB




INSERT INTO student VALUES(120,'李勇','男','20','CS');
INSERT INTO student VALUES(121,'张丽','女','19','CS');
INSERT INTO student VALUES(122,'刘晨','女','19','PAL');
INSERT INTO student VALUES(123,'王敏','女','20','ED');
INSERT INTO student VALUES(124,'谭梅','女','18','MB');
INSERT INTO student VALUES(125,'陈立','男','19','AL');
INSERT INTO student VALUES(126,'陈一','男','20','JW');
INSERT INTO student VALUES(127,'刘涛','男','18','MB');
INSERT INTO student VALUES(128,'梅芳','女','19','JW');
INSERT INTO student VALUES(129,'胡雨欣','女','18','PAL');
INSERT INTO student VALUES(130,'张喻','女','20','AL');
INSERT INTO student VALUES(131,'谭能言','男','19','AL');
INSERT INTO student VALUES(132,'何哞哞','男','20','ED');
INSERT INTO student VALUES(133,'周全量','男','19','AL');

INSERT INTO sc VALUES(120,1,92);
INSERT INTO sc VALUES(121,1,67);
INSERT INTO sc VALUES(122,1,82);
INSERT INTO sc VALUES(123,1,72);
INSERT INTO sc VALUES(124,1,68);
INSERT INTO sc VALUES(125,1,58);
INSERT INTO sc VALUES(126,1,83);
INSERT INTO sc VALUES(127,1,79);
INSERT INTO sc VALUES(128,1,52);
INSERT INTO sc VALUES(129,1,48);
INSERT INTO sc VALUES(130,1,88);
INSERT INTO sc VALUES(131,1,77);
  
 
INSERT INTO sc VALUES(120,2,92);
INSERT INTO sc VALUES(121,2,67);
INSERT INTO sc VALUES(122,2,82);
INSERT INTO sc VALUES(124,2,68);
INSERT INTO sc VALUES(125,2,58);
INSERT INTO sc VALUES(127,2,79);
INSERT INTO sc VALUES(130,2,88);
INSERT INTO sc VALUES(131,2,77);
INSERT INTO sc VALUES(132,2,88);
INSERT INTO sc VALUES(133,2,77);
 
 
 
INSERT INTO sc VALUES(120,1,92);
INSERT INTO sc VALUES(121,8,67);
INSERT INTO sc VALUES(122,9,82);
INSERT INTO sc VALUES(123,5,72);
INSERT INTO sc VALUES(124,7,68);
INSERT INTO sc VALUES(125,3,58);
INSERT INTO sc VALUES(126,6,83);
INSERT INTO sc VALUES(127,9,79);
INSERT INTO sc VALUES(128,10,52);
INSERT INTO sc VALUES(129,10,48);
INSERT INTO sc VALUES(130,8,88);
INSERT INTO sc VALUES(131,9,77);
INSERT INTO sc VALUES(132,3,88);
INSERT INTO sc VALUES(133,4,77);
 
 
INSERT INTO sc VALUES(120,4,92);
INSERT INTO sc VALUES(121,6,67);
INSERT INTO sc VALUES(122,9,82);
INSERT INTO sc VALUES(123,8,72);
INSERT INTO sc VALUES(124,7,68);
INSERT INTO sc VALUES(125,6,58);
INSERT INTO sc VALUES(128,10,52);
INSERT INTO sc VALUES(129,3,48);
INSERT INTO sc VALUES(130,4,88);
INSERT INTO sc VALUES(131,5,77);
INSERT INTO sc VALUES(132,6,88);
INSERT INTO sc VALUES(133,6,77);
 
 
 
INSERT INTO sc VALUES(120,7,92);
INSERT INTO sc VALUES(121,8,67);
INSERT INTO sc VALUES(122,9,82);
INSERT INTO sc VALUES(123,10,72);
INSERT INTO sc VALUES(124,7,68);
INSERT INTO sc VALUES(125,9,58);
INSERT INTO sc VALUES(126,8,83);
INSERT INTO sc VALUES(127,6,79);
INSERT INTO sc VALUES(128,1,52);
INSERT INTO sc VALUES(129,4,48);
INSERT INTO sc VALUES(130,6,88);
INSERT INTO sc VALUES(131,7,77);
INSERT INTO sc VALUES(132,9,88);
INSERT INTO sc VALUES(133,8,77)