sql ¶à±í¹ØÁª²éѯ

 create database example
use example
create table major
(
 spno varchar(10) primary key not null,
 spname varchar(20) not null
 )
 create table student
(
 sno varchar(10) primary key not null,
 sname varchar(10) not null,
 ssex varchar(2) not null,
 spno varchar(10) foreign key references major(spno)
)
create table course
( cno varchar(10) primary key not null,
  cname varchar(10) not null
 )
create table  scourse
(
 sno varchar(10) foreign key references student(sno),
 cno varchar(10) foreign key references course(cno),
 gmark int
)
insert into major values('001','Ó¢Óï')
insert into major values('002','ÓïÎÄ')
insert into major values('003','Êýѧ')
insert into major values('004','ÉúÎï')
insert into major values('005','ÎïÀí')
insert into major values('006','»¯Ñ§')
insert into student values('2007151301','bobo','ÄÐ','001')
insert into student values('2007151302','roy','ÄÐ','002')
insert into student values('2007151303','max','ÄÐ','004')
insert into student values('2007151304','tony','ÄÐ','004')
insert into student values('2007151305','jaims','ÄÐ','005')
insert into student values('2007151306','wing','ÄÐ','006')
insert into student values('2007151307','allen','ÄÐ','001')
insert into student values('2007151308','heng','ÄÐ','002')
insert into student values('2007151309','chart','ÄÐ','003')
insert into course values('001','ƹÅÒÇò')
insert into course values('002','ÀºÇò')
insert into course values('003','×ãÇò')
insert into course values('004','ÍøÇòÇò')
insert into course values('005','Î赸')
insert into course values('006','è¤Ù¤')
insert into course values('007','ÓÎÓ¾')
insert into scourse values('2007151301','001','88')
insert into scourse values('2007151302','002','88')
insert into scourse values('2007151303','003','88')
insert into scourse values('2007151304','004','88')
insert into scourse values('2007151305','005','88')
insert into scourse val