Klauzula HAVING

Klauzula HAVING dodatkowo doprecyzowuje wynik wyszukiwania klauzuli GROUP BY.  SELECT LOCATIONS.CITY, ROUND(AVG(EMPLOYEES.SALARY)) AS Średnie_wynagrodzenie, COUNT(EMPLOYEES.SALARY) AS Liczba_pracowników FROM DEPARTMENTS, LOCATIONS, EMPLOYEES  WHERE DEPARTMENTS.LOCATION_ID = LOCATIONS.LOCATION_ID […]