Task level Yandex/Meta. **Condition:** Divide user activity into sessions. A new session starts if more than 30 minutes have passed between actions. **Table:** user_sessions (user_id, action_time, action_type, page_url, device_type) **Requirements:** 1. For each action, determine session_id 2. Calculate for each session: start_time, end_time, duration_minutes, actions_count 3. Output user_id, session_id, start_time, end_time, duration_minutes, actions_count **Hint:** LAG +
Sign in to solve
Start Solving