試題詳解

10. 資料表 Staff 之欄位屬性定義：Id INTEGER、Name CHAR(20)、Dept INTEGER、Job CHAR(20)、Years INTEG ER、 Salary DECIMAL(10, 2)、Comm DECIMAL(10,2) ；欲表列「至少有一個員工的酬金(Comm)在 5,000 元以 上」之部門編號及員工總數，最能符合要求之 SQL 語法為何？
(A)SELECT Dept, COUNT(*) FROM Staff GRO UP BY Dept HAVING Comm>5000
(B)SELECT Dept, COUNT(*) FROM Staff WHERE Comm>5000 GROUP BY Dep t, Comm
(C)SELECT Dept, COUNT(*) FROM Staff GROUP BY Dept HAVING MAX(Comm)>5000
(D)SELECT Dept, Comm, COUNT(id) FROM Staff WHERE Comm>5000 GROUP BY Dept, Comm。