9. 資料表 Emp 之欄位屬性定義:Empid INTEGER、Name CHAR(20)、Deptno INTEGER、Sal INTEGER;欲表列 「部門代號 20 及 50 的員工平均薪資(Sal)在 22,000 元(含)以上」之部門代號(Deptno),最能符合要求之 SQL 語法為何?
(A)SELECT Deptno, AVG(Sal) FROM Emp WHERE Deptno IN (20,50) GROUP BY Deptno HAVING A VG(Sal)>=22000
(B)SELECT Deptno, AVG(Sal) FROM Emp GROUP BY Deptno HAVING AVG(Sal)>=22000 AND D eptno IN (20,50)
(C)SELECT Deptno, AVG(Sal) FROM Emp WHERE Deptno IN (20,50) AND AVG(Sal)>=22000 GRO UP BY Deptno
(D)SELECT Deptno, AVG(Sal) FROM Emp WHERE Deptno IN (20,50) GROUP BY AVG(Sal) HAVIN G AVG(Sal)>=22000。

答案:登入後查看
統計: A(15), B(0), C(2), D(0), E(0) #1126879