将 PUBS 数据库中的 TITLES 表中的 TYPE 按类型分,并求出 PRICE 的和,显示为价格,正确的SQL 语句是
A.
SELECT TYPE, COUNT(PRICE) AS 价格 FROM TITLES GROUP BY TYPE
B.
SELECT TYPE, SUM(PRICE) AS 价格 FROM TITLES GROUP BY TYPE
C.
SELECT TYPE, SUM(PRICE) AS 价格 FROM TITLES
D.
SELECT TYPE, COUNT (PRICE) AS 价格 FROM TITLES