[leetcode][Database][Hard]1972. First and Last Call On the Same Day

1 · ZhengWei, Liu · Dec. 6, 2022, 5:39 a.m.
題目 Table: Calls +--------------+----------+ | Column Name | Type | +--------------+----------+ | caller_id | int | | recipient_id | int | | call_time | datetime | +--------------+----------+ (caller_id, recipient_id, call_time) is the primary key for this table. Each row contains information about the time of a phone call between caller_id and recipient_id. Write an SQL query to report the IDs of the users whose first and last calls on...