By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ORA-00905: missing keyword
ORA-00904: "T"."FIRSTDATE": invalid identifier
ORA-00904: "ALIAS1": invalid identifier
ORA-00905: missing keyword
ORA-00904: "T"."FIRSTDATE": invalid identifier
ORA-00904: "ALIAS1": invalid identifier