I don't know __ _.[ ] A. how to do that 发布时间:2017-07-02 00:10 │ 来源:www.tikuol.com 题型:选择题 问题: I don't know __ _.[ ]A. how to do that B. how do that C. how do you do that
题型:选择题 查询订单数在3个以上、订单的平均金额200元以上的职员号。正确的SQL语句是( )。A) SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG_金额>200B) SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG(金额)>200C) SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 WHERE AVG(金额)>200D) SELECT 职员号 FROM 订单 GROUPBY 职员号 WHERE COUNT(*)>3 AND AVG_金额>200 查看答案