云南大学 软学院数据库试验5.docVIP

云南大学软件学院 实 验 报 告 姓名： 学号： 专业： 实验5 数据查询 1、完成教科书163页的如下习题： [3.2]b：select aid from AGENTS where [percent] =all (select MAX([percent]) from AGENTS) [3.5]：select aid,cid from AGENTS A,CUSTOMERS C where aid not in (select aid from ARDERS X where X.cid=C.cid and X.aid=a.aid) order by aid,cid [3.8]a：select cid,pid,MAX(dollars) as MAXSPENT from ARDERS group by cid,pid,dollars [3.8]b：select AVG (MAXSPENT) as AVERAGE from (select cid,pid,MAX(dollars) as MAXSPENT from ARDERS group by cid,pid,dollars) as x group by cid