Query: backup_plan_resource_assignment

with filtered_backup_plans as (
  select
    backup_plan_id
  from
    aws_backup_plan
  where
    arn = $1
    and account_id = split_part($1, ':', 5)
    and region = split_part($1, ':', 4)
)
select
  'Resource Assignments' as label,
  count(s.selection_name) as value
from
  aws_backup_selection s
join
  filtered_backup_plans p on s.backup_plan_id = p.backup_plan_id;