Analyze costs by service name v1.3

Postgres SQL, as run

select billing_period_start as billing_period_start,
       case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_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 total_billed_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, service_provider_name, sub_account_id, sub_account_name, service_name
order by billing_period_start, total_effective_cost desc nulls last, service_provider_name, sub_account_id, sub_account_name nulls last, service_name
limit 500

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

Original FOCUS SQL

SELECT
  BillingPeriodStart,
  ServiceProviderName,
  SubAccountId,
  SubAccountName,
  ServiceName,
  SUM(BilledCost) AS TotalBilledCost,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ServiceName = ?
  AND BillingPeriodStart >= ? AND BillingPeriodStart < ?
GROUP BY
  BillingPeriodStart,
  ServiceProviderName,
  SubAccountId,
  SubAccountName,
  ServiceName