--Zadanie 15
SELECT SYS_CONNECT_BY_PATH('','===>')||(level-1)||'           '||imie "Hierarchia", DECODE(szef, NULL, 'Sam sobie panem', szef) "Pseudo szefa", funkcja "Funkcja"
FROM Kocury
WHERE myszy_extra IS NOT NULL
CONNECT BY PRIOR pseudo=szef
START WITH szef IS NULL;

--Zadanie 16
SELECT  SUBSTR(SYS_CONNECT_BY_PATH(pseudo, '  '),3 ), SYS_CONNECT_BY_PATH(pseudo, '  ')
FROM Kocury
CONNECT BY PRIOR szef=pseudo
START WITH myszy_extra IS NULL AND ((MONTHS_BETWEEN(DATE '2018-06-20',w_stadku_od))/12) > 9 AND myszy_extra IS NULL AND plec='M';