Analyze Purchase of Virtual Currency
Inspect the result, its parameters and the SQL behind it.
- Source
- FOCUS use-case library
- Data
- FOCUS 1.0 sample
- Status
- Not in v1.0 sample
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Loading sample results
Inspect the result, its parameters and the SQL behind it.
No virtual-currency Purchase charges exist in the sample: the only Purchase rows have PricingUnit Hours and are AWS Savings Plan purchases.
SELECT
ProviderName,
PublisherName,
ChargeDescription,
PricingUnit,
BillingCurrency,
SUM(PricingQuantity) AS TotalPricingQuantity,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND ChargeCategory = 'Purchase'
AND PricingUnit = ?
GROUP BY
ProviderName,
PublisherName,
ChargeDescription,
PricingUnit,
BillingCurrency