PayPal·Data Scientist·Technical Phone Screen
- You're given a sessions table with session_id, start_time, and end_time. Write a SQL query that returns the session with the most overlaps with other sessions, along with the overlap count.
“Took me longer than I'd like to admit to land on the self-join approach.”