Leetcode Problem 1699. Number of Calls Between Two Persons

1699. Number of Calls Between Two Persons

Leetcode Solutions

Select the smaller of from_id and to_id using the LEAST function and alias it as person1.
Select the larger of from_id and to_id using the GREATEST function and alias it as person2.
Use COUNT(*) to calculate the number of calls between each pair and alias it as call_count.
Use SUM(duration) to calculate the total duration of calls between each pair and alias it as total_duration.
Group the results by person1 and person2 to ensure that each pair is counted only once.

erDiagram
    Calls {
        int from_id
        int to_id
        int duration
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen