Query: cloud_billing_report_overview_dashboard_top_10_projects

select
  project_id as "Project ID",
  round(sum(cost), 2) as "Total Cost"
from
  gcp_billing_report
where
  ('all' in ($1) or project_id in $1)
group by
  project_id
order by
  sum(cost) desc
limit 10;