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

Пікірлер: 1

  • @krishnayadav-rb2ei
    @krishnayadav-rb2ei21 күн бұрын

    This video is very helpful and informative for any enterprise 👍