Query: storage_account_age_table

select
  a.name as "Name",
  now() :: date - a.creation_time :: date as "Age in Days",
  a.creation_time as "Create Time",
  a.kind as "Kind",
  sub.title as "Subscription",
  a.subscription_id as "Subscription ID",
  a.resource_group as "Resource Group",
  a.region as "Region",
  lower(a.id) as "ID"
from
  azure_storage_account as a,
  azure_subscription as sub
where
  a.subscription_id = sub.subscription_id
order by
  a.creation_time,
  a.name;