Query: mysql_db_system_storage_by_tenancy

select
  t.title as "Tenancy",
  sum(data_storage_size_in_gbs) as "GB"
from
  oci_mysql_db_system as s,
  oci_identity_tenancy as t
where
  t.id = s.tenant_id and lifecycle_state <> 'DELETED'
group by
  t.title
order by
  t.title;