Query: sql_database_by_subscription

select
  s.title as "Subscription",
  count(d.*) as "Databases"
from
  azure_sql_database as d,
  azure_subscription as s
where
  s.subscription_id = d.subscription_id
group by
  s.title
order by
  s.title;