Analyze Purchase of Virtual Currency v1.3
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.
The sample contains no virtual-currency Purchase charges: its only Purchase rows are three AWS Compute Savings Plan fees priced in Hours, so the PricingUnit filter has no virtual-currency unit to select.
SELECT
ServiceProviderName,
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
ServiceProviderName,
PublisherName,
ChargeDescription,
PricingUnit,
BillingCurrency