简单应用题答案：
1 open data sdb
create view GRADELIST AS sele student.学号,姓名,成绩,课程名 from student,sc,course where 成绩>=60 and ;
student.学号=sc.学号 and sc.课程号=course.课程号 order by student.学号
sele * from GRADELIST into table v_grade
综合应用题答案：
“计算”菜单项的过程代码为：
SELECT 股票代码,SUM(本次数量) AS 持仓数量 FROM STOCK_MM WHERE 买卖标记 GROUP BY 股票代码 INTO CURSOR aaa
SELECT 股票代码,SUM(本次数量) AS 持仓数量 FROM STOCK_MM WHERE NOT 买卖标记 GROUP BY 股票代码 INTO CURSOR bbb
SELECT aaa.股票代码,(aaa.持仓数量-bbb.持仓数量) AS 持仓数量 FROM aaa,bbb WHERE aaa.股票代码=bbb.股票代码 ;
ORDER BY aaa.股票代码 INTO ARRAY ccc
DELETE FROM STOCK_CC
INSERT INTO STOCK_CC FROM ARRAY ccc
SELECT * TOP 1 FROM STOCK_CC ORDER BY 持仓数量 INTO TABLE STOCK_X
“退出”菜单项的命令代码为：set sysmenu to default
