YY4350 SQL 课后习题 （持续更新）

回忆搁浅

create table student(
      s_id int primary key not null,
     s_name varchar(20),
    s_age int ,

)

回忆搁浅

创建表：
create table student(
     s_id int primary key not null,
    s_name varchar(20),
     s_age int,
    s_sex varchar(10),
    s_x int
)

create table course
(
    cs_id int primary key not null,
    cs_name varchar(20),
   cs_keshishu  int
)


create table sc
(
    sc_id int primary key not null ,
   s_id int references studen(s_id),
   cs_id int references course(cs_id),
sc_score int
)

回忆搁浅

创建序列
create seqence seq_stu
start with 1
incrment by 1;
create sequence seq_cousre
start with 10
incrment by 1;
create sequence seq_sc
start with 1001
increment by 1;

回忆搁浅

(2)select a.s_id , a.s_name , c.sc_id, c.sc_score from student a inner join sc c on
c.s_id = a.s_id where a.s_x="06";

回忆搁浅

下班回家。、