LeetCode 1777 Amazon 'Product's Price for Each Store' Interview SQL Question Detailed Explanation

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

In this video I solve and explain a 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 1777 Amazon 0:07:10

LeetCode 1777 Amazon 'Product's Price for Each Store' Interview SQL Question Detailed...

LeetCode 1777: Product's 0:07:40

LeetCode 1777: Product's Price for Each Store [SQL]

MLV Prasad - 0:06:25

MLV Prasad - LeetCode SQL [ EASY ] | 1777 | 'Product's Price for Each Store' |

LeetCode 2329 'Product 0:07:06

LeetCode 2329 'Product Sales Analysis V' Amazon Interview SQL Question with Detailed Expla...

1164. Product Price 0:09:14

1164. Product Price at a Given Date | Leetcode SQL Medium

LeetCode 1082 Amazon 0:07:32

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

LeetCode 1082: Sales 0:05:44

LeetCode 1082: Sales Analysis I [SQL]

LeetCode 1821 Interview 0:04:24

LeetCode 1821 Interview SQL Question with Detailed Explanation | Practice SQL

LeetCode 1795 Interview 0:12:05

LeetCode 1795 Interview SQL Question with Detailed Explanation | Practice SQL

LeetCode 1511 Amazon 0:13:56

LeetCode 1511 Amazon & Facebook Interview SQL Question with Detailed Explanation | Practice SQL

LeetCode 1571 Interview 0:07:57

LeetCode 1571 Interview SQL Question with Detailed Explanation | Practice SQL

LeetCode Hard 2362 0:08:48

LeetCode Hard 2362 “Generate the Invoice' Interview SQL Question Explanation | EDS

LeetCode 1677 'Product's 0:10:31

LeetCode 1677 'Product's Worth Over Invoices' Interview SQL Question with Detailed Ex...

LeetCode Medium 2372 0:07:42

LeetCode Medium 2372 “Influence of Each Salesperson' Interview SQL Question Explanation | EDS

LeetCode 1741 Interview 0:06:56

LeetCode 1741 Interview SQL Question with Detailed Explanation | Practice SQL

LeetCode 1571: Warehouse 0:04:14

LeetCode 1571: Warehouse Manager [SQL]

Leetcode 1596: The 0:10:43

Leetcode 1596: The Most Frequently Ordered Products for Each Customer [SQL]

LeetCode 1322 'Ads 0:07:17

LeetCode 1322 'Ads Performance' Facebook (Meta) Interview SQL Question with Detailed Expla...

LeetCode 1565 Interview 0:09:54

LeetCode 1565 Interview SQL Question with Detailed Explanation | Practice SQL

MLV Prasad - 0:10:24

MLV Prasad - LeetCode SQL [ EASY ] | 1809 | 'Ad-Free Sessions' |

LeetCode Medium 2298 0:08:24

LeetCode Medium 2298 'Tasks Count in the Weekend' Interview SQL Question with Detailed Exp...

LeetCode 1069 Amazon 0:03:17

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

LeetCode 1484 | 0:03:23

LeetCode 1484 | Group Sold Products By The Date | Group_concat | SQL

LeetCode Medium 2159 0:09:52

LeetCode Medium 2159 Booking.com “Order 2 Columns Independently' Interview SQL Question Explana...

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

Here, MAX is used because:
we get [0, 95, null, null] max of this is 95.
Similarly, the rest.

toyszone
Автор

Can you help me understand why we took max here? we're only comparing the store1 which has only 1 value with the appropriate product_id. I didn't understood why we'll get the scenario of 95, null, null?

raghavarahulkalavala