FOCUSExplorer
Queries
Read-only sample

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

Quantify usage of a component resource 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

SkuPriceDetails (with its CoreCount and InstanceSeries properties) is absent from the v1.0 sample, so core counts by instance series cannot be summed.

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

Original FOCUS SQL
SELECT
    ServiceProviderName,
    ServiceName,
    PricingUnit,
    RegionName,
    JSON_UNQUOTE(JSON_EXTRACT(SkuPriceDetails, '$.InstanceSeries')) AS InstanceSeries, 
    SUM(CAST(JSON_UNQUOTE(JSON_EXTRACT(SkuPriceDetails, '$.CoreCount')) AS UNSIGNED)) AS TotalCoreCount
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
AND JSON_CONTAINS_PATH(SkuPriceDetails, 'all', '$.CoreCount', '$.InstanceSeries')
GROUP BY
    ServiceProviderName,
    ServiceName,
    PricingUnit,
    RegionName,
    InstanceSeries