CREATE TABLE Student (Sno CHAR(10), Sname CHAR(20), Ssex CHAR(1), Sage INT);
CREATE TABLE Course (Cno CHAR(10), Cname CHAR(20), Ccredit INT);
CREATE TABLE SC (Sno CHAR(10), Cno CHAR(10), Grade INT);
INSERT INTO Student VALUES('98131001','student0', 'F',20);
INSERT INTO Student VALUES('98131002','student1', 'F',21);
INSERT INTO Student VALUES('98131003','student2', 'F',22);
INSERT INTO Student VALUES('98131004','student3', 'F',23);
INSERT INTO Student VALUES('98131005','student4', 'F',24);
INSERT INTO Student VALUES('98131006','student5', 'M',25);
INSERT INTO Student VALUES('98131007','student6', 'M',26);
INSERT INTO Student VALUES('98131008','student7', 'M',27);
INSERT INTO Student VALUES('98131009','student8', 'M',28);
INSERT INTO Student VALUES('98131010','student9', 'M',29);
INSERT INTO Course VALUES('Cno0','CourseName0',4);
INSERT INTO Course VALUES('Cno1','CourseName1',4);
INSERT INTO Course VALUES('Cno2','CourseName2',4);
INSERT INTO Course VALUES('Cno3','CourseName3',4);
INSERT INTO Course VALUES('Cno4','CourseName4',4);
INSERT INTO Course VALUES('Cno5','CourseName5',4);
INSERT INTO Course VALUES('Cno6','CourseName6',4);
INSERT INTO Course VALUES('Cno7','CourseName7',4);
INSERT INTO Course VALUES('Cno8','CourseName8',4);
INSERT INTO Course VALUES('Cno9','CourseName9',4);
INSERT INTO SC VALUES('98131001','Cno1',71);
INSERT INTO SC VALUES('98131001','Cno2',81);
INSERT INTO SC VALUES('98131001','Cno3',91);
INSERT INTO SC VALUES('98131001','Cno4',89);
INSERT INTO SC VALUES('98131002','Cno1',90);
INSERT INTO SC VALUES('98131002','Cno2',62);
INSERT INTO SC VALUES('98131003','Cno2',85);
INSERT INTO SC VALUES('98131008','Cno1',50);
