This is an old revision of the document!
select last_name, to_char(hire_date, 'yyyy') as hy, (case when to_char(hire_date, 'yyyy')>1995 then 'jung' when to_char(hire_date, 'yyyy')>1992 then 'mittel' else 'alt' end) altersgruppe from employees order by hire_date desc;
decode