Query: cost_by_region_dashboard_region_costs

select
  line_item_usage_account_id as "Account",
  coalesce(product_region_code, 'global') as "Region",
  round(sum(line_item_unblended_cost), 2) as "Total Cost"
from
  aws_cost_and_usage_report
where
  ('all' in ($1) or line_item_usage_account_id in $1)
group by
  coalesce(product_region_code, 'global'),
  line_item_usage_account_id
order by
  sum(line_item_unblended_cost) desc;