LCF_lxf_ldy的博客

#建学生信息表studentcreate table student(sno varchar(20) not null primary key,sname varchar(20) not null,ssex varchar(20) not null,sbirthday datetime,class varchar(20));#建立教师表create table teacher...

数据库练习2(基于数据库练习1)1.查询“计算机导论”课程比“操作系统”课程成绩高的所有学生的学号;  SELECT sno,degree FROM score WHERE cno =(SELECT cno FROM course WHERE cname ='计算机导论' )  AND  degree > ALL(SELECT degree FROM score WHERE cno=(SEL...