試題詳解

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