编辑代码

CREATE DATABASE test;
use test;

create table Student(
Sno int(13) primary key auto_increment,
Sname varchar(50),
Ssex varchar(20),
Sborndate date,
Sdept varchar(50)
);

INSERT INTO Student VALUES (20180001,'张无忌','男','1999/3/6','数学系');
INSERT INTO Student VALUES (20180002,'李逍遥','男','1998/9/21','物理系');
INSERT INTO Student VALUES (20180003,'令狐冲','男','2000/2/29','物理系');
INSERT INTO Student VALUES (20180004,'任盈盈','女','2002/7/7','表演系');
INSERT INTO Student VALUES (20180005,'赵灵儿','女','2000/1/8','美术系');
INSERT INTO Student VALUES (20180006,'辛九狐','女','2001/6/6','表演系');


create table Course(
Cno int(13) primary key auto_increment,
Cname varchar(50),
Ccredit int(13)
);

INSERT INTO Course VALUES (101,'计算机原理',4);
INSERT INTO Course VALUES (102,'操作系统',5);
INSERT INTO Course VALUES (103,'数据库原理',3);
INSERT INTO Course VALUES (104,'离散数学',3);

create table SC(
Sno int(13) primary key auto_increment,
Cno int(13),
Grade int(13)
);

INSERT INTO SC VALUES (20180001,101,90);
INSERT INTO SC VALUES (20180001,102,95);
INSERT INTO SC VALUES (20180001,103,92);
INSERT INTO SC VALUES (20180001,104,88);
INSERT INTO SC VALUES (20180002,101,93);
INSERT INTO SC VALUES (20180002,102,85);
INSERT INTO SC VALUES (20180002,103,82);
INSERT INTO SC VALUES (20180003,102,91);
INSERT INTO SC VALUES (20180003,104,97);
INSERT INTO SC VALUES (20180004,101,90);
INSERT INTO SC VALUES (20180004,104,90);
INSERT INTO SC VALUES (20180005,101,90);
INSERT INTO SC VALUES (20180005,102,91);
INSERT INTO SC VALUES (20180006,103,94);