Query: installed_mods_by_platform

select
  case
    when
      title like '@turbot/aws%'
    then
      'AWS'
    when
      title like '@turbot/azure%'
    then
      'Azure'
    when
      title like '@turbot/gcp%'
    then
      'GCP'
    else 'Others'
  end
  as "Mod_Platform", count(title)
from
  guardrails_resource
where
  resource_type_uri = 'tmod:@turbot/turbot#/resource/types/mod'
group by
  "Mod_Platform";