Round 1: Coding and SQL queries -- 2 DSA questions, 2 scenario based SQL questions Round 2: Spark and Spark Structured Streaming -- internal workings, architecture Round 3: System Design -- Which stack you would use, which Data modelling techniques would you select

They asked one question for the F2F Coding Round. "1. Average Session Duration Part A – Daily Average Session Duration You are given a log file containing all login and logout events for a single day. Implement a program that computes the average session duration for every user. A session starts with a logged_in event and ends with a corresponding logged_out event. Assumptions Every login has a matching logout. Logs are ordered by timestamp. A user can have multiple sessions in a day. Example Input user: Tejashree | action: logged_in | time: 1736503565 user: Tejashree | action: logged_out | time: 1736507165 user: Tejashree | action: logged_in | time: 1736510765 user: Tejashree | action: logged_out | time: 1736517965 Output User: Tejashree, Avg Session Time: 5400 Explanation: Session 1 = 3600 seconds Session 2 = 7200 seconds Average = (3600 + 7200) / 2 = 5400 seconds" This was the question asked