|
&&prog6.prguse student6 in 0sele student6coun all to yx for 笔试>=90 and 上机>=90coun all to hg for (笔试=60)and (上机=60)coun all to bhg for 笔试<60or 上机<60 creat newtable6 (结论 C (10), 人数 N (3,0) )insert into newtable6 (结论,人数) value ("优秀",yx)insert into newtable6 (结论,人数) value ("合格",hg)insert |
