sql作业题答案_sql作业与答案

sql作业题答案由刀豆文库小编整理，希望给你工作、学习、生活带来方便，猜你可能喜欢“sql作业与答案”。

1.检索报名人数大于平均报名人数的课程名称和教师

selectcouname,teacher from course where willnum

select '班级编码'=student.clano,'班级名称'=claname,'学号'=stuno,'姓名'=stuname,'密码'=pwd from student join cla on student.clano=cla.clano order by student.clano compute count(student.clano)by student.clano 5.显示“00建筑管理”班级的系部、班级和学生信息，并计算班级人数。要求显示格式如下：

select cla.departno as '系部编码',departname as '系部名称',student.clano as '班级编码',claname as '班级名称', student.stuno as '学号',stuname as '姓名',pwd as '选课密码' from student join cla on cla.clano=student.clano join department on department.departno=cla.departno where cla.claname='00建筑管理' compute count(student.clano)6.检索陈金菊的个人信息，包括她选修的课程。select student.*,course.*

from student join stucou on student.stuno=stucou.stuno join course on course.couno=stucou.couno where stuname='陈金菊' 7.检索“00建筑管理”班有哪些学生。select student.*,claname from student join cla on student.clano=cla.clano where claname='00建筑管理' 8.显示计算机应用工程系的学生信息和系别名称，并统计计算机应用工程系有多少学生。select student.*,departname from student join cla on student.clano=cla.clano join department on department.departno=cla.departno where departname='计算机应用工程系' compute count(stuno)