- /*
- 显示部门名字、地区名称。
-
- SQL> SELECT D.DEPARTMENT_NAME,L.CITY,COUNT(*)
- 2 FROM EMPLOYEES E,DEPARTMENTS D,LOCATIONS L
- 3 WHERE E.DEPARTMENT_ID = D.DEPARTMENT_ID AND
- 4 D.LOCATION_ID = L.LOCATION_ID AND
- 5 E.SALARY > 1000
- 6 GROUP BY D.DEPARTMENT_NAME,L.CITY
- 7 HAVING COUNT(*) > 2;
-
- DEPARTMENT_NAME CITY COUNT(*)
-
- IT Southlake 5
- Sales Oxford 34
- Finance Seattle 6
- Shipping South San Francisco 45
- Executive Seattle 3
- Purchasing Seattle 6
-
- 6 rows selected
|