(49)

alter table 部门 add 人数 i

 

sele 部门号,count(雇员号)as 人数 from 雇员;

group by 部门号 into cursor aa

 

do while not eof()

update 部门 set 人数=aa.人数 where 部门号=aa.部门号

skip

enddo

 

sele * from 部门 into table dept

 

 

52

do case

case thisform.optiongroup1.value=1

open data salarydb

sele * from view1

sele * from view1  into table gzb

 

case thisform.optiongroup1.value=2

sele * from dept

sele * from  dept into table bmb

 

case thisform.optiongroup1.value=3

sele dept.*,sum(基本工资)as 基本工资 ,sum(津贴) as 津贴,;

sum(奖金)as 奖金,sum(失业保险) as 失业保险,sum(医疗保险) as 医疗保险;

from dept,salary where dept.部门号=salary.部门号;

group by salary.部门号 into table hzb

endcase

 

 

53

sele student.学号,课程编号,成绩 from student,score;

where student.学号=score.学号 and ;

系名="计算机" into table onetable

 

 

sele 姓名,课程名称,avg(成绩)as 平均成绩 from student a,;

course b,score c where  a.学号=c.学号 and c.课程编号=;

b.课程编号 group by c.学号 into table twotable