select min(售价)as'最低售价'
from 图书
select 条形码,书名
from 图书
order by 条形码
-
select avg(售价)as'平均售价' from 图书
select max(售价)as'最高售价',min(售价)as'最低售价',avg(售价)as'平均售价'
from 图书
select 条形码,书名,出版社,出版日期
from 图书
order by 出版社,出版日期 desc
select sno,sname
,(case when sex=1 then '男' else '女' end) as sex
from stu
select sno 学号,avg(grade) 平均成绩
from sc
group by sno
having avg(grade) > 75
select stu.sname as 姓名,sc.grade as 成绩
from sc
join cou on
cou.cno=sc.cno
join stu on
stu.sno=sc.sno and cou.cname='C语言'
order by 成绩 desc
select sno 学号,cname 课程名,grade 成绩
from cou,sc a
where cou.cno = a.cno and
(a.grade > (select avg(b.grade) from sc b where a.sno = b.sno))
select 读者.账号,读者.姓名,图书.条形码,图书.书名,借阅.借书日期,借阅.还书日期
from 借阅
join 图书 on
图书.条形码=借阅.条形码
join 读者 on
借阅.账号=读者.账号
select distinct 性别 ,count(性别) 人数
from 读者
group by 性别
select distinct 城市 ,count(城市) 顾客数
from 顾客
group by 城市