LeetCode 1699: Number of Calls Between Two Persons [SQL]

preview_player
Показать описание
Solution and walkthrough of leetcode database problem 1699: Number of Calls Between Two Persons. I'm using MySQL but this solution should work in any SQL dialect such as PostgreSQL, MS SQL Server, Oracle etc.

Playlists:

  1. Frederik Müller
  2. leetcode 1699
  3. lc 1699
  4. sql
  5. leetcode
  6. database
Рекомендации по теме
LeetCode 1699: Number 0:06:48

LeetCode 1699: Number of Calls Between Two Persons [SQL]

MLV Prasad - 0:09:22

MLV Prasad - LeetCode SQL [ MEDIUM] | 1699 | 'Number of Calls Between Two Persons' |

LeetCode 1699 - 0:09:29

LeetCode 1699 - Number of Calls Between Two Persons - SQL Solution

LeetCode Medium 1699 0:09:41

LeetCode Medium 1699 Facebook/Meta Amazon Interview SQL Question with Detailed Explanation

SQL Tutorials - 0:05:20

SQL Tutorials - Number of Calls Between Two Persons - Part 31

SQL Mastery for 0:06:02

SQL Mastery for High-Paying Jobs: Ultimate Interview Questions Guide! - Data Science | Leetcode 1699

LeetCode Medium 1715 0:08:59

LeetCode Medium 1715 Interview SQL Question with Detailed Explanation

LeetCode Medium 1867 0:07:26

LeetCode Medium 1867 Interview SQL Question with Detailed Explanation

115. Databricks | 0:16:52

115. Databricks | Pyspark| SQL Coding Interview: Number of Calls and Total Duration

LeetCode Medium 2112 0:10:28

LeetCode Medium 2112 Interview SQL Question with Detailed Explanation

1270. All People 0:07:22

1270. All People Report to the Given Manager| Leetcode SQL Medium

LeetCode Medium 1990 0:15:09

LeetCode Medium 1990 'Number of Experiments' Twitter Interview SQL Question Detailed Expla...

Google Coding Interview 0:21:03

Google Coding Interview Question - Number of Closed Islands (LeetCode)

MLV Prasad - 0:12:42

MLV Prasad - LeetCode SQL [ MEDIUM] | 1715 | 'Count Apples and Oranges' |

Customer Placing the 0:05:27

Customer Placing the Largest Number of Orders - Leetcode 586 | Week 4 | Qs 14 | SQL

First and Last 0:11:25

First and Last call for the day | Question 09 | Complex SQL Interview Problem

#Leetcode #SQLInterview #Database 0:17:05

#Leetcode #SQLInterview #Database Leetcode Database 1384. Total Sales Amount by Year

FACEBOOK/META LeetCode Medium 0:06:55

FACEBOOK/META LeetCode Medium 1264 “Page Recommendations' Interview SQL Question Explanation | ...

MLV Prasad - 0:09:30

MLV Prasad - LeetCode SQL [ EASY ] | 2668 | 'Find Latest Salaries' |

LeetCode 1715: Count 0:09:05

LeetCode 1715: Count Apples and Oranges [SQL]

LeetCode Interview SQL 0:09:04

LeetCode Interview SQL Question with Detailed Explanation | Practice SQL | LeetCode 613

Leetcode 1747 Leetflex 0:02:59

Leetcode 1747 Leetflex Banned Account

LeetCode 2072 Amazon 0:05:30

LeetCode 2072 Amazon Interview SQL Question with Detailed Explanation | Practice SQL

612. Shortest Distance 0:06:48

612. Shortest Distance in a Plane | Leetcode SQL Medium

Комментарии
Автор

This was asked of me in interview and cost me. Now, I know! Thx Fred

ThinkBigToday
Автор

Hey Fred
I have finished watching the entire Leetcode SQL playlist now, this a gold mine for SQL prep. simplified explanation and huge variety of queries
Thanks a ton!! Excellent job done here

mandeeplakra
Автор

Maaaan, that was a neat little solution. Thank you! And thank you for all these SQL exercises you've been sharing. Super useful and quite fun. ^^

ZzZzZiggy
Автор

Hey Fred
Thanks for sharing this method, I just a little bit confused about the order of execution, why we can use person 1 and person 2 in select clause as condition of group by? cause as far as I know, sql should execute from and group then last for SELECT is that right?

yuxinyang
Автор

this is very helpful, thanks for sharing

sachin-bcm
Автор

They asked me the same question in my interview and i failed to answer… but happy to know now…Thanks, , , ,

yourtechiefriend
Автор

Two self joins one on from and to, other between from=to and to= from and then aggregating might work

ajaxaj
Автор

Great to know those two functions!!
btw, I just finished your previous video, calculation salaries, and does it work for this question too by create one column like below?
I dont have Leetcode prime, do you mind take a look? Thanks!

Select from_id as person1, to_id as person2, count(selectedcalls.selected) as call_count, sum(duration) as total_duration
From
(Select from_id, to_id, duration, If(from_id < to_id, yes, no) as selected
From Calls
Group by from_id, to_id) selectedcalls
Where selected = ‘yes’

haowang
Автор

Would you be able to also solve it with UNION?

malikabaymuradova
Автор

This was really nice, and thanks for those two new functions :)

akritisaxena
Автор

ooo didn't know about those functions either. thanks man!

golammuhaimeen