Verify discount accuracy for previously invoiced billing period

Postgres SQL, as run

select provider_name as provider_name,
       billing_account_id as billing_account_id,
       billing_account_name as billing_account_name,
       billing_currency as billing_currency,
       service_name as service_name,
       sum(effective_cost) as total_effective_cost,
       sum(list_cost) as total_list_cost,
       sum(billed_cost) as total_billed_cost,
       ((sum(list_cost) - sum(effective_cost)) / nullif(sum(list_cost), 0)) * 100 as effective_discount
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
  and billing_period_end < $2::timestamptz
  and charge_class is distinct from 'Correction'
group by provider_name, billing_account_id, billing_account_name, billing_currency, service_name
order by total_effective_cost desc nulls last, provider_name, billing_account_id, billing_account_name nulls last, billing_currency nulls last, service_name
limit 500

Parameters: $1 = period_start, $2 = period_end_before

Original FOCUS SQL

SELECT
  ProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency,
  ServiceName,
  SUM(EffectiveCost) AS TotalEffectiveCost,
  SUM(ListCost) AS TotalListCost,
  SUM(BilledCost) AS TotalBilledCost,
  ((SUM(ListCost) - SUM(EffectiveCost)) / NULLIF(SUM(ListCost), 0)) * 100 AS EffectiveDiscount
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
  AND ChargeClass != 'Correction'
GROUP BY
  ProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency,
  ServiceName