LeetCode Medium 1459 'Rectangles Area' Twitter Interview SQL Question with Explanation

preview_player
Показать описание

In this video I solve and explain a medium difficulty leetcode SQL question using MySQL query. This question has been asked in Apple, Facebook, Amazon, Google, Adobe, Microsoft, Adobe interviews or what we popularly call FAANG interviews.
I explain the related concept as well. This question includes points to keep in mind to develop SQL queries.

LeetCode is the best platform to help you enhance your skills, expand your knowledge and prepare for technical interviews.

If you found this helpful, Like and Subscribe to the channel for more content.

#LeetCodeSQL #FAANG #SQLinterviewQuestions
  1. Everyday Data Science
  2. practice sql interview questions on leetcode
  3. solve sql interview questions
  4. how to solve sql interview questions
  5. leetcode sql queries
  6. leetcode sql questions
Рекомендации по теме
LeetCode Medium 1459 0:10:39

LeetCode Medium 1459 'Rectangles Area' Twitter Interview SQL Question with Explanation

MLV Prasad - 0:11:02

MLV Prasad - LeetCode SQL [ MEDIUM] | 1459 | 'Rectangles Area' |

223. Rectangle Area 0:10:47

223. Rectangle Area - Day 17/30 Leetcode November Challenge

223 || Rectangle 0:13:36

223 || Rectangle Area || Leetcode Daily Challenge

1205. Monthly Transactions 0:20:15

1205. Monthly Transactions II (Leetcode Medium)

LeetCode Medium 2041 0:06:37

LeetCode Medium 2041 Interview SQL Question with Detailed Explanation

LeetCode Medium 1501 0:15:09

LeetCode Medium 1501 'Countries You Can Safely Invest In' Interview SQL Question with Expl...

LeetCode Medium 1715 0:08:59

LeetCode Medium 1715 Interview SQL Question with Detailed Explanation

LeetCode Medium 2238 0:08:15

LeetCode Medium 2238 Interview SQL Question with Detailed Explanation

MLV Prasad - 0:10:25

MLV Prasad - LeetCode SQL [ MEDIUM] | 1468 | 'Calculate Salaries' |

LeetCode Medium 1709 0:12:54

LeetCode Medium 1709 Interview SQL Question with Detailed Explanation

MLV Prasad - 0:07:12

MLV Prasad - LeetCode SQL [ MEDIUM] | 1747 | 'Leetflex Banned Accounts' |

1841. League Statistics 0:10:26

1841. League Statistics | LeetCode SQL Solution [MEDIUM]

MLV Prasad - 0:09:02

MLV Prasad - LeetCode SQL [ MEDIUM] | 1440 | 'Evaluate Boolean Expression' |

LeetCode Medium 1112 0:07:34

LeetCode Medium 1112 Coursera Interview SQL Question with Detailed Explanation

578. Get Highest 0:05:49

578. Get Highest Answer Rate Question | Leetcode SQL Medium

1205. Monthly Transactions 0:15:22

1205. Monthly Transactions II | Leetcode SQL Medium

LeetCode Medium 1468 0:08:07

LeetCode Medium 1468 Interview SQL Question with Detailed Explanation

MLV Prasad - 0:05:01

MLV Prasad - LeetCode SQL [ MEDIUM] | 1445 | 'Apples & Oranges' |

LeetCode Medium 1532 0:11:25

LeetCode Medium 1532 Interview SQL Question with Detailed Explanation

MLV Prasad - 0:09:22

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

OPTUM LeetCode Medium 0:13:48

OPTUM LeetCode Medium 1555 “Bank Account Summary' Interview SQL Question Explanation | EDS

Leetcode Premium Questions 1:25:41

Leetcode Premium Questions | L 3 | Leetcode SQL Premium Series | Arpit Jain

LeetCode Hard 1479 0:14:51

LeetCode Hard 1479 'Sales by Day of the Week' Amazon Interview SQL Question with Explanati...

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

what if i do not use CTE? below solution is also accepted:
select p1.id as p1, p2.id as p2, abs(p1.x_value - p2.x_value) * abs(p1.y_value - p2.y_value) as area
from Points p1
cross join Points p2
#on p1.id = p2.id # no on clause in cross join
having area != 0 and p1< p2
order by area desc, p1, p2

roymou