Query: compute_instance_by_project

select
  p.title as "Project",
  count(i.*) as "total"
from
  gcp_compute_instance as i,
  gcp_project as p
where
  p.project_id = i.project
group by
  p.title
order by count(i.*) desc;