Analyze costs by service name

Postgres SQL, as run

select billing_period_start as billing_period_start,
       provider_name as provider_name,
       sub_account_id as sub_account_id,
       sub_account_name as sub_account_name,
       service_name as service_name,
       sum(billed_cost) as monthly_cost,
       sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where service_name = $1::text
  and billing_period_start >= $2::timestamptz
  and billing_period_start < $3::timestamptz
group by billing_period_start, provider_name, sub_account_id, sub_account_name, service_name
order by monthly_cost desc nulls last, billing_period_start, provider_name, sub_account_id nulls last
limit 500

Parameters: $1 = service_name, $2 = billing_period_start, $3 = billing_period_start_before

Original FOCUS SQL

SELECT
  BillingPeriodStart,
  ProviderName,
  SubAccountId,
  SubAccountName,
  ServiceName,
  SUM(BilledCost) AS MonthlyCost,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ServiceName = ?
  AND BillingPeriodStart >= ? AND BillingPeriodStart < ?
GROUP BY
  BillingPeriodStart,
  ProviderName,
  SubAccountId,
  SubAccountName,
  ServiceName
ORDER BY MonthlyCost DESC