Query: compute_snapshot_30_days_count

select
  count(*) as value,
  '1-30 Days' as label
from
  azure_compute_snapshot
where
  time_created between symmetric now() - '1 days' :: interval and now() - '30 days' :: interval;