       3 ),
     -- sku_metadata temporary table captures information about skus, such as CUD eligibility,
     -- whether the sku is vCPU or RAM, etc.
+    -- sku_metadata temporary table captures information about skus, such as CUD eligibility,
+    -- whether the sku is vCPU or RAM, etc.
     sku_metadata AS (
     SELECT
       sku_id,

      WHEN gcp_region IS NULL THEN NULL
      WHEN gcp_region LIKE "us-%"
    OR gcp_region LIKE "northamerica%"
    OR gcp_region LIKE "southamerica%" THEN "Americas"
      WHEN gcp_region LIKE "europe-%" THEN "EMEA"
      WHEN gcp_region LIKE "australia-%"
    OR gcp_region LIKE "asia-%" THEN"APAC" END);

        ELSE "Regular Usage"
      END AS cud_type,
      CASE
        WHEN LOWER(sku_description) LIKE "%americas%" OR LOWER(sku_description) LIKE "%los angeles%"
        OR LOWER(sku_description) LIKE "%sao paulo%" OR LOWER(sku_description) LIKE "%montreal%"
        OR LOWER(sku_description) LIKE "%virginia%" THEN "AMERICAS"
        WHEN LOWER(sku_description) LIKE "%emea%" OR LOWER(sku_description) LIKE "%netherlands%" OR
          LOWER(sku_description) LIKE "%frankfurt%" OR LOWER(sku_description) LIKE "%finland%"
          OR LOWER(sku_description) LIKE "%london%" THEN "EMEA"
        WHEN LOWER(sku_description) LIKE "%apac%" OR LOWER(sku_description) LIKE "%singapore%"
        OR LOWER(sku_description) LIKE "%japan%" OR LOWER(sku_description) LIKE "%hong kong%"
        OR LOWER(sku_description) LIKE "%mumbai%" OR LOWER(sku_description) LIKE "%sydney%" THEN "APAC"
        ELSE NULL
      END AS geo,
      -- for VM skus and commitments, "seconds" unit uniquely identifies vCPU usage
