-- Bitumen Effect / Bitumen Gap paired-series comparison

SELECT
    inc.activity,
    inc.index_oct_2025 AS index_including_bitumen,
    exc.index_oct_2025 AS index_excluding_bitumen,
    exc.index_oct_2025 - inc.index_oct_2025 AS index_gap,
    exc.pct_yoy - inc.pct_yoy AS yoy_gap_pp
FROM civil_material_index inc
JOIN civil_material_index exc
  ON inc.activity = exc.activity
WHERE inc.bitumen_treatment='included'
  AND exc.bitumen_treatment='excluded'
ORDER BY ABS(exc.pct_yoy - inc.pct_yoy) DESC;