《数据查询》练习的答案.docVIP

在教务管理数据库“EDUC”中进行操作： 学生表“Student”中查询出男生的学号、姓名、性别的数据信息。 select SID,Sname,Sex from Student where Sex 男select top 20 percent SID,Sname,Sex,Birthday from Student 学生表“Student”中查询出学校各专业的名称（不允许出现重复字段） select distinct specialty from Student 学生表“Student”中查询出学生赵成刚的信息。 select * from Student where Sname 赵成刚select * from Student where Sex 男select * from Student where Birthday 1985-12-1 学生表“Student”中查询出在‘1985-12-1’之前出生的女学生的信息 select * from Student where Birthday 1985-12-1 and Sex 女select * from Student where Sname like 李%select * from Student where SID 座机电话号码07 or SID 座机电话号码7 学生表“Student”中查询出各专业的学生总数，要求查询结果显示专业名称和人数两个列 select specialty,count * as 人数 from Student group by specialtyselect specialty,count * as 人数 from Student group by specialty having count * 4select top 5 bid,bname,author from book 读者类型表“ReaderType”中查询出所有数据。 select * from ReaderType 图书表“book”中查询出所有图书折价90%后的价格 select bid,bname,author,pubcomp,price,price*0.9 as 折价后的价格 from bookselect count * as 册数 from book where pubcomp 高等教育出版社select count distinct pubcomp as 出版社个数 from book select count price as 册数,max price as 最高价, min price as 最低价, sum price as 总价值,sum price*0.9 as 折价后的总价值,avg price as 平均价 from book select bid,bname,price from book where price between 10 and 15 图书表“book”中查询有关ERP方面的图书。 select * from book where bname like %ERP% 从表“Borrow”中查询还没有归还的图书的信息。 select book.* from book,borrow where book.bid borrow.bid and borrow.returndate is null 图书表“book”中查询各出版社图书的总价。 select pubcomp,sum price as 总价 from book group by pubcompselect * from book order by pubcomp asc,price desc