Query: compute_disk_age_table

select
  d.name as "Name",
  d.id :: text as "ID",
  now() :: date - d.creation_timestamp :: date as "Age in Days",
  d.creation_timestamp as "Create Time",
  d.status as "Status",
  p.name as "Project",
  p.project_id as "Project ID",
  d.location as "Location",
  d.self_link as "Self-Link"
from
  gcp_compute_disk as d,
  gcp_project as p
where
  p.project_id = d.project
order by
  d.creation_timestamp,
  d.name;