Debug: Window Alias Used in WHERE

Fix this query. SELECT user_id, event_time, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY event_time DESC) AS rn FROM user_events WHERE rn = 1;

user_events(user_id, event_time)