2B.WHERECOUNT(工程號(hào))>2C.HAVING(DIS..."/>
給定供應(yīng)關(guān)系 SPJ(供應(yīng)商號(hào),零件號(hào),工程號(hào),數(shù)量),查詢至少供應(yīng)了 3 項(xiàng)工程(包含 3 項(xiàng))的供應(yīng)商,輸出其供應(yīng)商號(hào)和供應(yīng)零件數(shù)量的總和,并按供應(yīng)商號(hào)降序排列。
SELECT 供應(yīng)商號(hào),SUM(數(shù)量)FROM SPJ
(1)
(2)
(3) ;
(1)
A.ORDER BY 供應(yīng)商號(hào) DESC
B.GROUP BY 供應(yīng)商號(hào) DESC
C.ORDER BY 供應(yīng)商號(hào)
D.GROUP BY 供應(yīng)商號(hào)
(2)
A.HAVING COUNT(DISTINCT(工程號(hào)))>2
B.WHERE COUNT(工程號(hào))> 2
C.HAVING(DISTINCT(工程號(hào)))> 2
D.WHERE 工程號(hào)> 2
(3)
A.ORDER BY 供應(yīng)商號(hào) DESC
B.GROUP BY 供應(yīng)商號(hào) DESC
C.ORDER BY 供應(yīng)商號(hào)
D.GROUP BY 供應(yīng)商號(hào)