IntermediateWHERE & Filtering

Find projects that are overdue

The query

SQL

SELECT
  project_id,
  name,
  end_date,
  CURRENT_DATE - end_date AS days_overdue,
  dept_id
FROM projects
WHERE status = 'active'
  AND end_date < CURRENT_DATE
ORDER BY days_overdue DESC;

Tested against PostgreSQL 16

Note

“Date subtraction returns integer days in PostgreSQL. Useful for project management dashboards.

Tables referenced

projects7 cols