LeetCode Medium 1934 Interview SQL Question with Detailed Explanation

Question: leetcode.com/p...
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

[@afiqaiman8012]

Thank you, love this easy answer with best explanation 😊. I hope you never stop make leetcode questions tutorial like this

[@xuyiang3307]

Thank you so much, great explaination ever by showing output inbetween really help me a lot in understanding the logic of this shit.

[@_hulk748]

Great explanation sir

[@vijaysakthivel4966]

Great explanation sir. Thank you so much

[@xzlog6747]

00:01 Solving LeetCode medium question on confirmation rate 01:28 Calculating confirmation rate using SQL query 02:58 Using GROUP BY and SUM to count confirmed actions for each user 04:25 Calculating confirmation rate for user requests 05:55 Perform a left join between the signups and confirmations table on the user ID. 07:26 Handling null values in the confirmation rate calculation 08:56 Calculating confirmation rate by grouping user IDs 10:30 Performing calculation and handling confirmation rates using SQL Thank you so much

[@nakulmehta797]

can anyone help me i am not getting when to apply which join i know the concepts of join but face difficulty while solving questions

[@randb9378]

Could you have used coalesce instead of case when?

[@lucyqin4536]

Nice solution! Can I please get some understanding here why we do not need to use IF or case here to tell if it is true for the condition c.action='confirmed'? Thanks a lot!

[@sagarkumbari4828]

we need to get the user_id where he has not requested any confirmation. so we need to use if else

[@kushaleregowda]

Thank you so much for your patience and detailed expectations. I’m at intermediate level in sql but I need to get into advanced level. Hence can you please suggest the best way/ approach/resources to follow..

[@EverydayDataScience]

Hi Kushal, so to transition from intermediate to advanced SQL, you should learn concepts like CTEs, Window Functions, Group by extensions like ROLLUP, CUBE,Dynamic CTEs and some other concepts. A simple google search can tell you about the list of concepts. Then you can specifically target each topics and solve SQL questions from resources like Leetcode or various books. Also what I found most useful was to think of using advanced SQL functions to solve even easy/intermediate questions because it will help you understand the exact ways how those advanced functions work.

[@kushaleregowda]

@@EverydayDataScience Thanks a lot 😊

[@minimumeffort1997]

This is actually a very good solution. Thanks.

[@EverydayDataScience]

Glad that you found the video useful 😊

[@rupdeepthey]

Well explained!

[@EverydayDataScience]

Glad that you found the video useful 😊

[@mlvprasadofficial]

NICE NEW LOGO ☀

[@EverydayDataScience]

Thanks, MLV.