SELECT SUM(o.revenue) / COUNT(DISTINCT p.user_id) AS arppu,
e.event_dt
FROM online_store.orders o
JOIN online_store.profiles p ON o.user_id = p.user_id
JOIN online_store.events e ON p.user_id=e.user_id
GROUP BY e.event_dt
;