Введение в модель данных SQL


Пример 15.16.1


WITH PRO1 (PRO_EDATE, PRO_NO) AS

(SELECT PRO_SDATE + PRO_DURAT, PRO_NO

FROM PRO)

SELECT COUNT (*), PRO_EDATE, AVG_SAL

FROM (SELECT PRO_EDATE, AVG (EMP_SAL)

FROM PRO1, EMP

WHERE PRO1.PRO_NO = EMP.PRO_NO

GROUP BY PRO1.PRO_NO) AS PRO_AVG_SAL (PRO_EDATE, AVG_SAL)

GROUP BY PRO_EDATE, AVG_SAL;




- Начало -  - Назад -  - Вперед -



Книжный магазин