37

sele stud.学号,姓名,avg(成绩)as 平均成绩,min(成绩) as 最低分;

from stud,scor where stud.学号=scor.学号 and ;

stud.学号  not in(sele 学号 from scor where 成绩 <60);

group by scor.学号 order by STUD.学号 desc ;

into table cjtemp

 

41

sele 组别,sum(金额) as 合计;

from empl,order where empl.职工号=order.职工号;

group by 组别 into cursor aa

 

sele aa.组别,姓名 as 负责人,合计 from aa,empl ;

where aa.组别=empl.组别 and 职务="组长"  order by 合计 desc;

into table hjtable

 

 

(42)

sele * from book where at("计算机",书名)>0 into table pcbook

update pcbook set 价格=价格*1.05

sele 出版单位,min(价格)as 价格 from pcbook where 价格>=28 into table temp

 

 

(43)

sele * from or_detail into table det_bak

 

update det_bak set 订单号=right(allt(订单号),1)

 

sele 订单号,配件号,配件名,min(单价) as 单价,sum(数量)as 数量;

from det_bak group by 订单号,配件号 order by 订单号,配件号 into table det_new

 

44

sele count(出版单位) FROM books where 出版单位=thisform.combo1.value into array a

thisform.text1.value=a

 

 

 

 

48

sele  运动员名称,项目名称,名次 from 国家,获奖牌情况;

where 国家.国家代码=获奖牌情况.国家代码 ;

and 国家名称=allt(thisform.list1.value);

order by 名次 into table allt(thisform.list1.value)