查询orders中劲霸西服的订单总金额,下列语句不正确的是
A.
select sum(d_price) from Orders join Goods on Orders.g_ID=Goods.g_ID and g_Name=‘劲霸西服’ group by Orders.g_ID
B.
select sum(d_price) from Orders join Goods on Orders.g_ID=Goods.g_ID where g_Name=‘劲霸西服’ group by Orders.g_ID
C.
select sum(d_Price) from Orders group by g_ID having g_ID=(select g_ID from Goods where g_Name='劲霸西服’)
D.
select sum(d_price) from Orders join Goods on Orders.g_ID=Goods.g_ID group by Orders.g_ID having g_Name=‘劲霸西服’