假设“订单”表中有订单号、职员号、客户号和金额字段,现查询哪些签订的订单数大于3并且平均金额超过200的职员信息____________。
A.
SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG_金额>200
B.
SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG(金额)>200
C.
SELECT 职员号 FROM 订单 GROUP,BY 职员号 HAVING COUNT(*)>3 WHERE AVG(金额)>200
D.
SELECT 职员号 FROM 订单 GROUP BY 职员号 WHERE COUNT(*)>3 AND AVG_金额>200