Identify and rank the top charge categories driving virtual-currency consumption to target optimization efforts.
Column names from the source use case.
PricingCurrency and PricingCurrencyEffectiveCost (and HostProviderName) are absent from the v1.0 sample, so virtual-currency consumption cannot be attributed to services.
SELECT
ServiceProviderName,
HostProviderName,
ServiceName,
ChargeDescription,
SUM(PricingCurrencyEffectiveCost) AS TotalPricingCurrencyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND PricingCurrency = ?
GROUP BY
ServiceProviderName,
HostProviderName,
ServiceName,
ChargeDescription
ORDER BY TotalPricingCurrencyEffectiveCost DESC
LIMIT 10