基本操作题答案：
4、Update PRODUCTS set 优惠价格=进货价格*(1-0.12)
综合应用题答案：
先在命令窗口输入下列命令:
OPEN DATABASE GZ3
CREATE TABLE GJ3(职工号 C(4),工资 N(4))
“查询”菜单项的过程代码为：
SELECT 职工号 FROM DGD WHERE 供应商号 IN ("S4","S6","S7") GROUP BY 职工号 HAVING COUNT(DISTINCT 供应商号)=3 ;
INTO CURSOR aaa
SELECT ZG.职工号,工资 FROM ZG,aaa WHERE ZG.职工号=aaa.职工号 ORDER BY 工资 DESC INTO ARRAY bbb
INSERT INTO GJ3 FROM ARRAY bbb
