FOCUSExplorer
Queries
Read-only sample

FOCUS 1.0 billing data. Reference snapshots are dated on each page.

Analyze Purchase of Virtual Currency v1.3

Inspect the result, its parameters and the SQL behind it.

← All queries
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
Source
FOCUS use-case SQL
Status
Not in v1.0 sample
Results
Not run
Mode
Read-only
Library snapshot (UTC)
2026-10-08

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.

Review the original SQL below and the required columns before using a newer FOCUS dataset.

Original FOCUS SQL
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