Query: project_expiring_member_table

select
  p.full_path as "Project",
  m.username as "Member",
  m.access_desc as "Access Level",
  m.expires_at :: date - now() :: date as "Expires in Days",
  p.web_url,
  m.web_url as member_url
from
  gitlab_my_project p
  join gitlab_project_member m on p.id = m.project_id
where
  m.state = 'active'
  and m.expires_at is not null
order by
  "Expires in Days";