mysql -- 练习5

创建表student1，并插入数据

drop table if EXISTS student1;
CREATE table student1 (
Sno int  PRIMARY KEY,
Sname  varchar(10),
Sex   varchar(5),
Sage    TINYINT,
Sdept varchar(20)
);

insert into Student1 values
('9512101','李勇','男',19,'计算机系'),
('9512102','刘晨','男',20,'计算机系'),
('9512103','王敏','女',20,'计算机系'),
('9521101','张立','男',22,'信息系'),
('9521102','吴宾','女','21','信息系'),
('9521103','张海','男',20,'信息系'),
('9531101','钱小平','女',18,'数学系'),
('9531102','王大力','男',19,'数学系');

 

创建表course1，并插入数据

drop table if EXISTS course1 ;
create table course1(
Cno   varchar(10) PRIMARY key ,
Cname  varchar(10),
hours int
);

insert into course1 values 
('C01',   '计算机文化学',  70),
('C02',   'VB' ,           90),
('C03',   '计算机网络',    80),
('C04',   '数据库基础 ',  108),
('C05',   '高等数学' ,    180),
('C06',   '数据结构',     72);

 

 创建表sc1，并插入数据

drop table if EXISTS sc1 ;
create table sc1(
Sno  int ,
Cno  varchar(10),
Grade  int 
);

insert into SC1 values
('9512101','c01',90),
('9512101','c02',86),
('9512101','c06',NULL),
('9512102','c02',78),
('9512102','c04',66),
('9521102','c01',82),
('9521102','c02',75),
('9521102','c04',92),
('9521102','c05',50),
('9521103','c02',68),
('9521103','c06',NULL),
(&