IntermediateBasic SELECT

Select all employees and their years of experience

The query

SQL

SELECT
  first_name,
  last_name,
  hire_date,
  EXTRACT(YEAR FROM AGE(CURRENT_DATE, hire_date)) AS years_exp
FROM employees
ORDER BY years_exp DESC;

Tested against PostgreSQL 16

Note

“AGE() returns an interval. EXTRACT(YEAR FROM AGE(...)) gives whole years.