-- Synthetic Theory fixture. No customer data.
CREATE TABLE calc.normalised AS
SELECT
    account_id,
    raw_value / 100.0 AS normalised_value
FROM stg.readings;