Caller History - Amazon Interview Question - SQL

Given a phone log table that has information about callers' call history, find out the callers whose first and last calls were to the same person on a given day. Output the caller ID, recipient ID, and the date called.
Companies appeared in: Amazon, Etsy
Difficulty: Medium
Ideas: SQL Window Functions (ROW_NUMBER), Common Table Expressions (CTE)
Problem: t.ly/1aVUO

[@krishnayadav-rb2ei]

This video is very helpful and informative for any enterprise 👍