Problem
Solution
WITH Average AS (
SELECT event_type, AVG(occurences) as occurences
FROM Events
GROUP BY event_type
...