Query: accounts_by_provider

select
  case
    when resource_type_uri = 'tmod:@turbot/aws#/resource/types/account' then 'AWS'
    when resource_type_uri = 'tmod:@turbot/azure#/resource/types/subscription' then 'Azure'
    when resource_type_uri = 'tmod:@turbot/gcp#/resource/types/project' then 'GCP'
    when resource_type_uri = 'tmod:@turbot/servicenow#/resource/types/instance' then 'ServiceNow'
  end
  as "Account Type", count(resource_type_uri)
from
  guardrails_resource
where
  resource_type_uri in
  (
    'tmod:@turbot/aws#/resource/types/account', 'tmod:@turbot/azure#/resource/types/subscription', 'tmod:@turbot/gcp#/resource/types/project', 'tmod:@turbot/servicenow#/resource/types/instance'
  )
group by
  resource_type_uri;