Query: snapshot_by_region

select
  s_regions,
  count(d.*) as "Snapshots"
from
  digitalocean_snapshot as d,
  jsonb_array_elements(regions) as s_regions
group by
  s_regions;