皮皮学，免费搜题
登录
搜题
【单选题】
假设进货表如下表所示,要统计各类产品的货物种数、平均单价、货物总量,下列SQL语句正确的是A.
SELECT 产品类型,SUM(货物名称) AS 货物种数,AVG(单价) AS 平均单价,SUM(数量) AS 货物总量 FROM 进货表 GROUP BY 产品类型
B.
SELECT 产品类型,COUNT(*) AS 货物种数,AVG(单价) AS 平均单价,SUM(数量) AS 货物总量 FROM 进货表 GROUP BY 产品类型
C.
SELECT 产品类型,COUNT(*) AS 货物种数,AVG(单价) AS 平均单价,COUNT(数量) AS 货物总量 FROM 进货表 GROUP BY 产品类型
D.
SELECT 货物名称,COUNT(*) AS 货物种数,AVG(单价) AS 平均单价,SUM(数量) AS 货物总量 FROM 进货表 GROUP BY 货物名称
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
反馈参考答案：
举一反三
【单选题】If it were not for the fact that she ________ sing , I would invite her to the party.
A.
couldn ’ t
B.
shouldn ’ t
C.
can ’ t
D.
might not
【简答题】【T14】 A. ALL AF THAT B. AS IF IT WERE C. FRESH WATER SUPPLY D. IN THIS FIELD A. A LIMITED【T13】______ B. SO THAT IT CAN BE USED AGAIN JUST【T14】______ FROM A SPRING C. AND WE CANNOT EVEN USE【T15】______ ...
【简答题】【T20】 A. ALL AF THAT B. AS IF IT WERE C. FRESH WATER SUPPLY D. IN THIS FIELD A. A LIMITED【T13】______ B. SO THAT IT CAN BE USED AGAIN JUST【T14】______ FROM A SPRING C. AND WE CANNOT EVEN USE【T15】______ ...
【简答题】【T16】 A. ALL AF THAT B. AS IF IT WERE C. FRESH WATER SUPPLY D. IN THIS FIELD A. A LIMITED【T13】______ B. SO THAT IT CAN BE USED AGAIN JUST【T14】______ FROM A SPRING C. AND WE CANNOT EVEN USE【T15】______ ...
【简答题】实习报告的写作要求?
【简答题】【T15】 A. ALL AF THAT B. AS IF IT WERE C. FRESH WATER SUPPLY D. IN THIS FIELD A. A LIMITED【T13】______ B. SO THAT IT CAN BE USED AGAIN JUST【T14】______ FROM A SPRING C. AND WE CANNOT EVEN USE【T15】______ ...
【单选题】已知函数y＝f(x)在定义域内可导，则函数y＝f(x)在某点处的导数值为0是函数y＝f(x)在这点处取得极值的
A.
充分不必要条件
B.
必要不充分条件
C.
充要条件
D.
非充分非必要条件
相关题目：
参考解析：
知识点：
题目纠错 0
发布
