1、学生表
1.1、有学生表student和班级表class,写出一条sql语句查询出得分在最高的学生
select Name
,Score from stu_1
where Score = (select MAX(Score) from stu_1)
1.2、写一条sql语句 查询出一班、二班的人数和平均分,并且按照由高到低排序
select COUNT(*),avg(a.Score) from stu_1 as a,class as b
where a.C_id = b.ID group by b.Name
order by a.Score DEC
1.3、写一条sql语句查询出没有班级的学生名字、性别、分数
select Name
,Sex,Score from stu_1 where stu_1.Name
not in(
select a.Name
from stu_1 as a,class as b where a.C_id = b.ID)
2、保单车辆表
有一个【保单车辆】数据库,数据库包括三个表:
报单表:保单号(po)、被保险人(iname)、产品类型(pc)、保险起期(state)、保险止期(edat