CTE statement causes "Table doesn't exist in engine" error

CREATE TABLE deviceEvents (

	id INT AUTO_INCREMENT PRIMARY KEY,

	deviceID INT NOT NULL,

	event JSON NOT NULL,

	occurredAt DATETIME NOT NULL

);

INSERT INTO deviceEvents (deviceID, event, occurredAt) VALUES

(101, '{"type": "login", "user": "admin", "status": "success"}', NOW() - INTERVAL 55 MINUTE),

(102, '{"type": "data_sync", "records_synced": 152, "source": "cloud", "temperature": 35.5}', NOW() - INTERVAL 50 MINUTE),

(103, '{"type": "status_report", "battery_level": 85, "signal_strength": "good", "temperature": 32.1}', NOW() - INTERVAL 45 MINUTE),

(101, '{"type": "settings_change", "setting": "brightness", "value": 75}', NOW() - INTERVAL 40 MINUTE),

(102, '{"type": "error", "code": "E-802", "message": "Device overheating", "temperature": 85.5}', NOW() - INTERVAL 35 MINUTE),

(104, '{"type": "login", "user": "guest", "status": "success"}', NOW() - INTERVAL 30 MINUTE),

(101, '{"type": "data_sync", "records_synced": 34, "source": "local", "temperature": 38.0}', NOW() - INTERVAL 25 MINUTE),

(103, '{"type": "low_battery_warning", "battery_level": 15, "temperature": 29.5}', NOW() - INTERVAL 20 MINUTE),

(102, '{"type": "temperature_reading", "value": 33.7, "unit": "Celsius"}', NOW() - INTERVAL 15 MINUTE),

(101, '{"type": "logout", "user": "admin"}', NOW() - INTERVAL 10 MINUTE);

WITH RankedEvents AS (

  SELECT

    occurredAt,

    event,

    -- This is the window function that does the magic

    ROW_NUMBER() OVER (

      PARTITION BY DATE(occurredAt), HOUR(occurredAt) 

      ORDER BY occurredAt ASC

    ) as row_num

  FROM

    deviceEvents

  WHERE

    deviceID = 5 AND

    JSON_EXTRACT(event, '$.temperature') IS NOT NULL

)

SELECT

  occurredAt,

  JSON_EXTRACT(event, '$.temperature') as temperature

FROM

  RankedEvents

WHERE

  row_num = 1

ORDER BY

  occurredAt ASC;