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

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

[prathamsarraf]

You are doing amazing work bhaiya even your channel is so under rated even after bringing so much quality content how go get motivated to upload new videos

[ibinagautam]

Your channel is very useful!! Just subscribed. Please make more videos on leetcode sql and stratascratch sql. Thank you for your explanation!!

[pritamm]

why we are using group by and having in cte 2 actual we already grouped it together by customer_id, month and year wise ?
...so for each month and each customer ....it would be greater than 100 ..just by using .. where clause