WITH NAMES AS
(
	SELECT NAME
	FROM EMPLOYEE
	WHERE DEPARTMENT_ID = 1
),
POSITIONS AS
(
	SELECT POSITION
	FROM EMPLOYEE
	WHERE DEPARTMENT_ID = 1
)
SELECT DISTINCT NAME, POSITION
FROM NAMES CROSS JOIN POSITIONS
ORDER BY NAME;
-----------------------------------------------------------------
WITH CHIEF AS
(
	SELECT FK_CHIEF_ID, AVG(SALARY) AS AVERAGE_WORKERS_SALARY
	FROM EMPLOYEE
	WHERE PK_ID <> FK_CHIEF_ID
	GROUP BY FK_CHIEF_ID
)
SELECT PK_ID, NAME, SALARY, AVERAGE_WORKERS_SALARY
FROM CHIEF JOIN EMPLOYEE ON CHIEF.FK_CHIEF_ID = EMPLOYEE.PK_ID
WHERE SALARY > AVERAGE_WORKERS_SALARY * 2
ORDER BY NAME