【无标题】

select min(售价)as'最低售价'
from 图书

 

 

select 条形码,书名
from 图书
order by 条形码

 

1. 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 城市