INSERT INTO S VALUES ('0005','Jimmy','male',20,'SX')
INSERT INTO S VALUES ('0003','Jane','female',21,'JSJ')
INSERT INTO S VALUES ('0001','Jesse','male',20,'SX')
INSERT INTO S VALUES ('0009','Walter','male',20,'SX')
INSERT INTO S VALUES ('0002','Saul','male',23,'JSJ')
INSERT INTO S VALUES ('0004','Jerry','female',22,'SX')
INSERT INTO S VALUES ('0091','Babara','female',20,'SX')
INSERT INTO S VALUES ('0078','Wang','male',21,'JSJ')
GO
INSERT INTO C(Cno,Cname,Ccredit) VALUES ('1001','gdsx',5)
INSERT INTO C VALUES ('1002','lssx','1001',3)
INSERT INTO C(Cno,Cname,Ccredit) VALUES ('1003','cxsj',5)
INSERT INTO C VALUES ('1004','sjjg','1003',4)
INSERT INTO C VALUES ('1005','sjkgl','1004',4)
GO
INSERT INTO SC VALUES ('0002','1002',90)
INSERT INTO SC VALUES ('0002','1001',91)
INSERT INTO SC VALUES ('0002','1003',67)
INSERT INTO SC VALUES ('0002','1004',98)
INSERT INTO SC VALUES ('0001','1002',92)
INSERT INTO SC VALUES ('0001','1001',80)
INSERT INTO SC VALUES ('0001','1003',76)
INSERT INTO SC VALUES ('0003','1001',77)
INSERT INTO SC VALUES ('0001','1004',91)
INSERT INTO SC VALUES ('0004','1001',97)
INSERT INTO SC VALUES ('0004','1002',78)
INSERT INTO SC VALUES ('0004','1003',65)
INSERT INTO SC VALUES ('0004','1004',89)
INSERT INTO SC VALUES ('0091','1001',93)
INSERT INTO SC VALUES ('0091','1002',87)
INSERT INTO SC VALUES ('0091','1003',45)
INSERT INTO SC VALUES ('0091','1004',67)
INSERT INTO SC VALUES ('0009','1001',67)
INSERT INTO SC VALUES ('0009','1002',88)
INSERT INTO SC VALUES ('0009','1003',79)
INSERT INTO SC VALUES ('0009','1004',83)
GO
