8.6作业

-- 学生表
create table school.stu(
        s_id varchar(10) primary key,
    s_name varchar(10) not null,
    s_age date not null,
    s_sex varchar(10) default \"未知\");
   
insert into school.stu values
(\'01\' , \'赵雷\' , \'1990-01-01\' , \'男\')        ,
(\'02\' , \'钱电\' , \'1990-12-21\' , \'男\')        ,
(\'03\' , \'孙风\' , \'1990-05-20\' , \'男\')        ,
(\'04\' , \'李云\' , \'1990-08-06\' , \'男\')        ,
(\'05\' , \'周梅\' , \'1991-12-01\' , \'女\')        ,
(\'06\' , \'吴兰\' , \'1992-03-01\' , \'女\')        ,
(\'07\' , \'郑竹\' , \'1992-04-21\' , \'女\')        ,
(\'08\' , \'王菊\' , \'1990-01-20\' , \'女\')       
;

-- 课程表
create table school.co(
        c_id varchar(10) primary key,
    c_name varchar(10) not null,
    t_id varchar(10) not null);
   
insert into school.co values
(\'01\' , \'语文\' , \'02\'),
(\'02\' , \'数学\' , \'01\'),
(\'03\' , \'英语\' , \'03\');

-- 教师表
create table school.te(
        t_id varchar(10) primary key,
    t_name varchar(10) not null);
   
insert into  school.te values
(\'01\' , \'张三\'),
(\'02\' , \'李四\'),
(\'03\' , \'王五\');

-- 成绩表
create table school.sc(
        s_id varchar(10) not null,
    c_id varchar(10) not null,
    score int not null);
   
insert into school.sc values
(\'01\' , \'01\' , 80),
(\'01\' , \'02\' , 90),
(\'01\' , \'03\' , 99),
(\'02\' , \'01\' , 70),
(\'02\' , \'02\' , 60),
(\'02\' , \'03\' , 80),
(\'03\' , \'01\' , 80),
(\'03\' , \'02\' , 80),
(\'03\' , \'03\' , 80),
(\'04\' , \'01\' , 50),
(\'04\' , \'02\' , 30),
(\'04\' , \'03\' , 20),
(\'05\' , \'01\' , 76),
(\'05\' , \'02\' , 87),
(\'06\' , \'01\' , 31),
(\'06\' , \'03\' , 34),
(\'07\' , \'02\' , 89),
(\'07\' , \'03\' , 98)
;