Query: open_epic_table

select
  g.full_path as "Group",
  title as "Epic",
  now()::date - e.created_at::date as "Age in Days",
  now()::date - e.updated_at::date as "Days Since Last Update",
  author as "Author",
  e.web_url,
  g.web_url as group_url
from
  gitlab_group g
  join gitlab_epic e on e.group_id = g.id
where
  e.state = 'opened'
order by
  "Age in Days" desc;