在一数据库中有以下关系:员工,Employee(EID,name,department)产品,Product(PID,name,model)仓库,Warehouse(WlD,location,EID)库存,Inventory(WID,PID,Qty)完成下面的SQL查询语句,使之能查询每种产品的名称及其库存总量:SELECT name,SUM(Qty) FROM Product,Inventory WHERE()。
A.Product.PID=Inventory.PID
B.Product.PID=Inventory.PID 0RDER BY name
C.Product.PID=Inventory.PID GROUP BY name
D.Produet.PID=Inventory.PID SUM BY name