LeetCode 1495 'Friendly Movies Streamed Last Month' Amazon Interview SQL Question with Explanation

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

[dgvj]

First of all thank you so much for your videos. Love your content and the way you teach.
I have a quick question here Why we are doing left join here and not the inner join ?

[roymou]

Hello, thank you for your solutions. can we not use inner joins instead of left join?

with cte as
(select *, month(program_date) as mnth, year(program_date) as yr
from TVProgram
)

select distinct title
from cte c
join Content cn
on c.content_id = cn.content_id
where Kids_content = "Y" and mnth = 6 and yr = 2020 and content_type = "Movies"