Problem Description –
Write an SQL query to report the distinct titles of the kid-friendly movies streamed in June 2020.
Return the result table in any order.
The query result format is in the following example.
Problem Link – Friendly Movies
Difficulty Level – Easy
SELECT DISTINCT c.title FROM TvProgram as tv JOIN Content as c ON tv.content_id = c.content_id WHERE c.kids_Content = 'Y' AND DATE_FORMAT(tv.program_date, '%Y-%m') = '2020-06' AND c.content_type = 'Movies'