Clarification

[silviudanielpopescu]

Hi Mo,
Only a small clarification here - "Who is the oldest employee?" query is returning the age not the name of the oldest employee...
Your question is opening a challenge and accept it - I will come back with the solution.
Thanks.

[silviudanielpopescu]

Found a way:

SELECT *, AGE(birth_date) AS "Age" FROM employees
ORDER BY "Age" DESC;
6 records matching...

[ai77ee]

that's right!
I spent so much time thinking how to resolved it in order to get who is the oldest employee
and I came with this solution:

select *,  AGE(birth_date)
from employees
WHERE AGE(birth_date)=(
select  MAX(AGE(birth_date)) 
from employees
)

and yep! there's 6 records matching who is the oldest employee

[AAB007209]

@silviudanielpopescu @aimeehg
You can do a simple query as well instead of writing big queries. First find the minimum birth_date using
" SELECT min(employees.birth_date) FROM employees; "........ and then do this below query.
SELECT employees FROM public.employees WHERE employees.birth_date = '1952-02-01';

Why min birth_date is because they are the oldest employees.