根据MXB创建一个名为YP的视图,该视图包含每种药品的药品号和销售总价,下列正确的语句是______。
A.
SELECT 药品编号,SUM(数量*单价) AS 销售总价; FROM MXB INTO VIEW YP
B.
CREATE VIEW YP AS; SELECT 药品编号,SUM(数量*单价) AS 销售总价; FROM MXB; GROUP BY 药品编号
C.
CREATE VIEW YP AS; SELECT 药品编号,SUM(数量*单价) AS 销售总价; FROM MXB; ORDER BY 药品编号
D.
CREATE YP AS VIEW; SELECT 药品编号,SUM(数量*单价) AS 销售总价; FROM MXB; ORDER BY 药品编号