Analyze cost per compute service for a subaccount

Postgres SQL, as run

select min(charge_period_start) as first_charge_period_start,
       max(charge_period_end) as last_charge_period_end,
       service_name as service_name,
       resource_id as resource_id,
       resource_name as resource_name,
       sum(pricing_quantity) as total_pricing_quantity,
       sum(effective_cost) as monthly_effective_cost
from focus.cost_and_usage
where sub_account_id = $1::text
  and service_category = 'Compute'
  and charge_period_start >= $2::timestamptz
  and charge_period_end < $3::timestamptz
group by service_name, resource_id, resource_name
order by monthly_effective_cost desc nulls last, resource_id
limit 500

Parameters: $1 = sub_account_id, $2 = period_start, $3 = period_end

Original FOCUS SQL

SELECT
  Min(ChargePeriodStart),
  Max(ChargePeriodEnd),
  ServiceName,
  ResourceId,
  ResourceName,
  SUM(PricingQuantity),
  SUM(EffectiveCost) AS MonthlyEffectiveCost
FROM focus_data_table
WHERE SubAccountId = ?
  AND ServiceCategory = 'Compute'
  AND ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  ServiceName,
  ResourceId,
  ResourceName
ORDER BY MonthlyEffectiveCost DESC