Query: my_open_issue_table

select
  i.title as "Issue",
  p.full_path as "Project",
  now() :: date - i.created_at :: date as "Age in Days",
  now() :: date - i.updated_at :: date as "Days Since Last Update",
  author as "Author",
  i.web_url,
  p.web_url as project_url
from
  gitlab_my_issue i
  inner join gitlab_project p on i.project_id = p.id
where
  i.state = 'opened'
order by
  "Age in Days" desc;