Window Function to Rank Within Group

Given the table events(user_id INT, event_time TIMESTAMP, event_type STRING, revenue DECIMAL(10,2)), write a SQL query that returns the single latest event for every user. The result must contain: user_id event_time event_type revenue Requirements: Order events for each user by descending event_time. When a user has multiple events at the same timestamp, select the event with the greater revenue. Use a window function, for example ROW_NUMBER(), to choose one row per user.…