FAANG| OnSite, Data Engineer 5th cat | Avg wait time

Your rideshare log table populated in real-time with events like login, estimated time of arrival, pick-up, drop-off.
There could be duplicates.
How would you calculate an avg wait time? Log Table structure: session_id, user_id, event_code, event_ts.

Comments (1)