EasyBasic SELECT

List all projects with their status and budget

The query

SQL

SELECT
  project_id,
  name AS project_name,
  status,
  start_date,
  end_date,
  budget,
  CASE
    WHEN end_date < CURRENT_DATE THEN 'Overdue'
    WHEN end_date IS NULL THEN 'No deadline'
    ELSE 'On track'
  END AS timeline_status
FROM projects
ORDER BY start_date DESC;

Tested against PostgreSQL 16

Note

“CASE expression adds computed columns dynamically — no stored column needed.

Tables referenced

projects7 cols